SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Articles with tags Administering, Triggers, Advanced Querying Rss

Search for any content tagged Administering & Triggers & Advanced Querying

   Items 1 to 1 of 1   
 

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: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 11,585 reads
   Items 1 to 1 of 1