Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server - Disable all triggers on database

Jul 27 2011 3:45AM by Ramireddy   

Just learned from Pinal Dave's blog about disabling all triggers on database. You can use the below query to disable all triggers.

DISABLE TRIGGER ALL ON DATABASE

To disable triggers on all servers

DISABLE TRIGGER ALL ON ALL SERVER
Read More..   [46 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Ramireddy
2 · 40% · 12972
8
 
2
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

2  Comments  

  • you can also enable all triggers ENABLE TRIGGER ALL ON DATABASE

    ENABLETRIGGER ALL ON ALL SERVER

    Nice one! Thanks for sharing!

    commented on Jul 27 2011 4:11AM
    MAKAROV
    713 · 0% · 46
  • This command will not disable any of the normal triggers (defined on tables). It will only disable the DDL triggers defined on the database scope.

    commented on Aug 8 2011 11:19PM
    Razvan Socol
    178 · 1% · 278

Your Comment


Sign Up or Login to post a comment.

"SQL Server - Disable all triggers on database" rated 5 out of 5 by 8 readers
SQL Server - Disable all triggers on database , 5.0 out of 5 based on 8 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]