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

Content with tag sp_msforeachdb Rss

   Items 1 to 6 of 6   
 

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,668 reads

Change all of your database owners

globally change all the database owners on a server.  Read more...
By @STLSQLGuy 2010/09/08 | Source: SQLServerCentral.com | Category: sp_msforeachdb
Rating: |  Discuss |   Briefcase | 2,135 reads

Search for a Table in all databases

This Script can be used for searching a Table in SQL server 2005  Read more...
By Sandesh Segu 2009/08/04 | Source: SQLServerCentral.com | Category: table search
Rating: |  Discuss |   Briefcase | 1,044 reads

Find information about all databases

ALL database information  Read more...
By umar iqbal 2009/04/28 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 2,072 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

Find Guest user access level in all databases

Search for GUEST Access Level in all   Read more...
By Mani Singh 2008/08/06 | Source: SQLServerCentral.com | Category: sp_msforeachdb
Rating: |  Discuss |   Briefcase | 1,263 reads
   Items 1 to 6 of 6   
 
Tags
administrator (1)    
databases (1)    
db_owner (1)    
deprecated (1)    
dynamic sql (1)    
guest user (1)    
like (1)    
run (1)    
script (1)    
security (1)    
sp_changedbowner (1)    
sp_helpdb (1)    
sql server 2005 (1)    
system stored procedure (1)    
table search (1)    
t-sql (1)    
video (1)