The query below is meant to only return tables with the name "Factor" in them, but I'm getting stored procs back as well. How do filter out the stored procs and only get tables?
DECLARE @ObjectName varchar(40)SET @ObjectName = '%Factor%'select o.[name] databasename, o.[name] tablename,c.[name] columnname from syscolumns c,sysobjects owhere o.id = c.id AND o.[name] LIKE @ObjectName ORDER BY tableName