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
Showing posts with label View All Trigger. Show all posts
Showing posts with label View All Trigger. Show all posts
Wednesday, February 6, 2008
Subscribe to:
Posts (Atom)
