SELECT * FROM SYSOBJECTS
WHERE XType = 'tr'
To view the trigger code execute the following statement. Replace the <Trigger_Name> with actual trigger name
SP_HELPTEXT <Trigger_Name>
May 13, 2008
How to know what are the triggers present in the Database
Execute the following statements in Sql Server Management Studio.
To view the trigger code execute the following statement. Replace the <Trigger_Name> with actual trigger name
To view the trigger code execute the following statement. Replace the <Trigger_Name> with actual trigger name
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment