Drop Triggers 1

[klewis10367]

Is there a stored procedure or script that will drop all of my triggers on a database?

 

[ptheriault]

If you run this it will create a script to that you can then run to drop all your triggers. I haven't tested this so you should run this in test first to make sure it doesn't drop anything you need to keep.

select 'DROP TRIGGER '+name
from sysobjects
WHERE xtype = 'TR'

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[klewis10367]

Perfect. I just added a like condition to the name, because I named custom triggers different