Wednesday, January 5, 2011

How to Find all triggers in sql server along with table to which triggers are applied

Here is the way to find out all the triggers in sql server tables along with table to which it applies.

SELECT  NAME AS TriggerName,OBJECT_NAME(parent_obj) AS TableName FROM sysobjects WHERE xtype='TR'

No comments:

Post a Comment