Snippets
DZone 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

Snippets has posted 5883 posts at DZone. View Full User Profile

Temporarily Enable/disable Trigger (SQL Server)

07.21.2008
| 8370 views |
  • submit to reddit 
        
ALTER TABLE tablename DISABLE TRIGGER ALL 
-- do work here 
ALTER TABLE tablename ENABLE TRIGGER ALL
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers