Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, Stored Procedures, Advanced Querying, Administration Rss

   Items 1 to 2 of 2   

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 2,818 reads

Creating your own sp_MSforeach stored procedure

This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.   Read more...
By Brian Knight 2002/06/17 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 15,005 reads
   Items 1 to 2 of 2   
dba (1)    
maintenance and management (1)    
sql server 2008 (1)    
sql server 7 (1)    
triggers (1)