Showing posts with label View All Trigger. Show all posts
Showing posts with label View All Trigger. Show all posts

Wednesday, February 6, 2008

How to view all triggers

To view the trigger from a particular database Table
exec sp_helpTrigger @tabname='QTQuotationMaster'

If you want to see all the triggers available in the database then run this
SQL Server 2000:
select * from sysobjects where xtype ='TR'

SQL Server 2005:
Select * from sys.triggers