Simple query

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 1

You'll have to walk through the databases on the server. Try something like this. It'll work, but it's not perfect.

sp_msforeachdb 'select DB_NAME() AS ''DBName''

FROM INFORMATION_SCHEMA.TABLES t

WHERE t.TABLE_NAME = ''Customer'''

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Adam Haines SSC-Insane Points: 23217 More actions · Answer 2

You should use the foreachdatabase.

EXEC master..sp_MSForeachdb '

USE [?]

IF DB_ID(''?'')>4

BEGIN

IF EXISTS(SELECT 1

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME = ''Customer'')

BEGIN

PRINT ''?''

END

'

Adam Haines SSC-Insane Points: 23217 More actions · Answer 3

Same concept but a little different twist.

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 4

Yeah, always more than one way to skin a cat.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt