Just Learned - SQL Server - Disable all triggers on database

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

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

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 · · · ·

Previous: c# - When Static Fields will be initialized and Order of execution
Next: TRY_PARSE() - A new Conversion function in SQL Server Denali CTP3

Ramireddy

2 · 41% · 12972

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it

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

703 · 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

176 · 1% · 278

Sign Up or Login to post a comment.