SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • Simulating undocumented Procedures

    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''' Because...
    Posted to Madhivanan (Weblog) by Madhivanan on Tue, May 13 2008
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems