Monday, May 19, 2008 - Posts

Simulating undocumented Procedures
19 May 08 12:00 PM | Madhivanan | 2 Comments   
Sometimes you may want to run a query against each database Suppose you want to find all dabase names where particular table exists. You can use undocumented procedure EXEC sp_msforeachdb 'SELECT table_catalog FROM ?.INFORMATION_SCHEMA.TABLES where table_name=''your_table''' Read More...
Filed under: ,