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: 12% [?]

Related posts:

1. Sql Server Interview Questions – Part 1
2. Using OVER() with Aggregate Functions in Sql Server 2005
3. CASE Function in SQL Server 2005
4. Create Database,Table and Procedure in Sql Server – Beginners
5. Check Sql Server database is Case Sensitive or Insensitive (Collation)