How to find the table name in the database that have triggers

SELECT DISTINCT o.[name] AS [Table]
FROM [sysobjects] o
JOIN [sysobjects] tr
ON o.[id] = tr.[parent_obj]
WHERE tr.[type] = 'tr'
ORDER BY [Table]

If you want to know all name of the triggers then run the query

select * from sys.triggers

hope it'll helpfull

Comments

Popular posts from this blog

Unable to add google gmail in iphone

Understanding ASP.NET MVC using real world example, for beginners and intermediate

iphone review