SELECT DISTINCT o.name, o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%Timetable%'
select a.name from sysobjects a
inner join syscolumns b on a.id = b.id
where a.xtype='U'
and b.name = 'siteid'
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%Timetable%'
select a.name from sysobjects a
inner join syscolumns b on a.id = b.id
where a.xtype='U'
and b.name = 'siteid'