George2: Created page with " 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 ''?..."

2016-01-29T17:06:35Z

Created page with "<source lang="sql"> 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 ''?..."

New page

<source lang="sql">
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

</source>

How to locate a table by table name - Revision history

George2: Created page with " 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 ''?..."