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,029 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,016 reads

Find information about all databases

ALL database information  Read more...
By umar iqbal 2013/05/21 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 1,840 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,093 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,228 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)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.