DamianSuess/TSQL-SearchTriggers.md

Last active January 3, 2019 15:56

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/DamianSuess/6df8984be8d8dab139aeb1f64ab3171b.js"></script>
Save DamianSuess/6df8984be8d8dab139aeb1f64ab3171b to your computer and use it in GitHub Desktop.

Download ZIP

TSQL Search triggers

Raw

TSQL-SearchTriggers.md

The following example shows you how to search the database's triggers for a string using MS SQL Server 2000-2017

Example

-- Search all Triggers (rev 1)
-- Usage: Replace '%...%' with you search string
SELECT
  Tables.Name TableName,
  Triggers.name TriggerName,
  Triggers.crdate TriggerCreatedDate,
  Comments.Text TriggerText
FROM
  sysobjects Triggers
  Inner Join sysobjects Tables On Triggers.parent_obj = Tables.id
  Inner Join syscomments Comments On Triggers.id = Comments.id
WHERE
  Triggers.xtype = 'TR' and Tables.xtype = 'U'
  and Comments.Text like '%...%'
ORDER BY Tables.Name, Triggers.name

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment