Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag sp_msforeachdb Rss

Search for any content tagged sp_msforeachdb

   Items 1 to 2 of 2   
 

sp_msforeachdb: Improving on an Undocumented Stored Procedure

Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!  Read more...
By Edward Pollack 2014/12/01 | Source: SQLServerCentral.com | Category: sp_msforeachdb
Rating: |  Discuss |   Briefcase | 8,656 reads

Using SP_MSForEachDB and SP_MSForEachTable - SQL School Video

In this new video, learn how to loop through your databases and tables. MVP Andy Warren shows how some system stored procedures included by Microsoft can push out the same code to a group of objects.  Read more...
By Andy Warren 2009/03/26 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,266 reads
   Items 1 to 2 of 2