Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Temporarily enable/disable trigger (SQL Server) (See related posts)

   1  
   2  ALTER TABLE tablename DISABLE TRIGGER ALL 
   3  -- do work here 
   4  ALTER TABLE tablename ENABLE TRIGGER ALL
to trigger SQL Server disable enable by deostroll on Mon Jul 21 20:05:51 -0400 2008

You need to create an account or log in to post comments to this site.


Click here to browse all 5521 code snippets

Related Posts