June 19th, 2009 
joy To view the existing triggers in the database
SELECT * FROM sys.triggers OR SELECT * FROM sysobjects WHERE xtype='TR'
To view the existing triggers in a specified table
sp_helptrigger tablename
To drop a trigger
DROP TRIGGER triggername
To drop more triggers at a time
DROP TRIGGER [trigger1],[trigger2],[trigger3]...[triggern]
Popularity: 9% [?]
Posted in 
Tags: 
