cookieChoices = {};

Wednesday, 4 May 2016

Disable and Enable All Trigger for database

Disable and Enable All Trigger for database
Use Database_Name  
  
Exec sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"


Use Demo  
  
Exec sp_msforeachtable "ALTER TABLE ? ENABLE TRIGGER all"
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)