Click here to Skip to main content
13,139,569 members (49,107 online)
Click here to Skip to main content
Articles » Database » Database » General » Downloads

Tagged as

Stats

10.3K views
8 bookmarked
Posted 19 Jan 2010

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...
No downloads associated with this content

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

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

Share

About the Author

Manas Bhardwaj
Architect
Netherlands Netherlands

Read my personal blog at www.manasbhardwaj.net.


You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170915.1 | Last Updated 19 Jan 2010
Article Copyright 2010 by Manas Bhardwaj
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid