How can I make query to find "ClientID = 2660" in all tables in The Database?

Quick and Dirty


in Sql , set Results to Text

Run this query

SELECT 'Select * from ' + dbo.sysobjects.Name + ' where ClientID = 2660' FROM dbo.syscolumns

INNER JOIN dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.ID

WHERE dbo.syscolumns.Name = 'ClientID'



Then copy the queries it makes, past them into a query window, and run them