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
Wednesday, February 6, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment