Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » General » Downloads
 
Add your own
alternative version

Programitically retrieve the trigger definition

, 19 Jan 2010
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...

License

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

About the Author

Manas Bhardwaj
Architect
Netherlands Netherlands
Read my personal blog at www.manasbhardwaj.net.
Follow on   Twitter

| Advertise | Privacy | Mobile
Web01 | 2.8.140709.1 | Last Updated 19 Jan 2010
Article Copyright 2010 by Manas Bhardwaj
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid