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 5 of 5   
 

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,112 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,039 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,014 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,232 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,255 reads
   Items 1 to 5 of 5   
 
Tags
administrator (1)    
databases (1)    
db_owner (1)    
guest user (1)    
like (1)    
run (1)    
script (1)    
security (1)    
sp_changedbowner (1)    
sp_helpdb (1)    
sql server 2005 (1)    
table search (1)    
t-sql (1)    
video (1)