Loading ...

Find list of triggers in SQl Server | CodeAsp.Net

Find list of triggers in SQl Server

 /5
0 (0votes)

Today I need to make changes in trigger but I forgot the name of trigger and associated table with it.

So quickly find out the list of triggers associated with the tables in a database, I used following query.

USE [YourDatabaseName]

SELECT [Name] AS TriggerList,
	OBJECT_NAME(parent_id) AS TableList,
	create_date AS CreatedDate,
	modify_date AS ModifiedDate
FROM sys.triggers ORDER BY [Name]

Below is the screen shot of results, when I run the above query in msdb database(System database) in SQL Server 2005.

 

Note: I have tested this query only in SQl Server 2005.

Comments (no comments yet)

Top Posts