Trigger question

[sujosh]

How do I see the trigger I created on a table using sql query analyzer. I used to do a sp_help on sqlserver7 and could see all of them. But with sql server 2000 I dont get the trigger systax when I do sp_help

ANy reasons?
Thanks

 

[tlbroadbent]

I don't know if there is a stored procedure to do this but you can find the text of triggers in syscomments.

Select o.name, c.text
from syscomments c
inner join sysobjects o
on c.id=o.id
where o.type='tr'

Make sure you have set the Maximmum characters per column on the Query Analyzer options (Results tab) to a large value such as 8192 in order to display all of the TEXT.
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[sujosh]

Thanks Terry!!

Really appreciate it.

 

[balves]

sp_helptext?

Syntax
sp_helptext [ @objname = ] 'name'

Prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, or view.