Get the text of all the triggers in a database

This is a pretty simple piece of code, it shows how to get the text of all the triggers in the database. I'm blogging it not for it's value as code, but I needed it today and I had to search for it. By blogging it I can put it on the 'SQL General' menu (see the link above) and I won't have to search for it again <smiles>


Calling a web service from SQL
Case sensitive SQL queries
Connection String Example
Copy ANY TABLE from one database to another
Create (and restore a database to) a TEST server for app testing
Creating a date calendar table
Find table and field a particular value reside
Find tables that have no permissions granted, and fix them
Get a person's age from their birthdate
Get the text of all the triggers in a database
Group by Grouping Sets example
How to format T-SQL
Insert an image into a SQL table from SQL
Log the user that changed a field
Loop through a string and show ASCII characters
Paging query contest
Parsing @tags from a SQL text field
Query that adds a blank like to the result set if the original resultset has more than one line
Remove unwanted characters from a field in SQL
sp_send_dbmail example
SQL code to resequence a grid
SQL Trigger Nest Level
Strip leading zeros
Suppress the results of a stored procedure
Table Value Constructors

... and you 'll find more on the SQL (General) Menu

select t.name, Comments.*

from sys.triggers t

Inner Join syscomments Comments On t.object_id = Comments.id

where Comments.text like '%audit%'

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.

Links
Home
Knowledge Areas
Sitemap

Contact

Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences

Get the text of all the triggers in a database

Related Articles

... and you 'll find more on the SQL (General) Menu