Click here to Skip to main content
15,867,453 members
Articles / Programming Languages / SQL

Programitically retrieve the trigger definition

Rate me:
Please Sign up or sign in to vote.
4.85/5 (4 votes)
19 Jan 2010CPOL 14K   8  
I ran into this strange situation where I wanted to get Trigger Definition(the SQL content) of a specific trigger from a database. The following SQL query can used to retrieve the trigger definition programitically.SELECT DB_NAME() AS DataBaseName, dbo.SysObjects.Name AS...

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect
Netherlands Netherlands

Read my personal blog at www.manasbhardwaj.net.


Comments and Discussions