Run in Query Analyzer:
Use database name
Go
Select * from sysobjects where xtype=' TR '
sysobjects holds the object of the database, where the record xtype as TR is the trigger object. We can see the name of the trigger in the Name column.
- SQL triggers-Create a simple trigger
- SQL triggers-rename triggers
- SQL triggers-delete triggers
- SQL triggers-triggers more syntax
- SQL triggers-How to view the contents of a trigger
- SQL triggers-Multiple triggers
- SQL triggers-recursive, nested triggers
- SQL triggers-trigger rollback
- SQL triggers-use triggers with caution
- SQL Triggers-table replication and triggers
- SQL triggers-Create a trigger on a view
- SQL triggers-Disabling and enabling triggers
- SQL triggers-does cascading deleted records trigger triggers?
- SQL triggers-inserted, deleted virtual tables
- SQL triggers-trigger trigger sequence when cascading deletes
SQL triggers-how to see which triggers are in the current database
