Difference between revisions of "How to locate a table by table name"

CREATE TABLE #t (
    DBName sysname NOT NULL
)
GO
EXEC sp_msforeachdb 'use [?]; if OBJECT_ID(''dbo.staff'') is not null insert into #t (DBName) select ''?'''
GO
SELECT * FROM #t
GO
DROP TABLE #t