How to Script Only the triggers in a SQL 2008 database?

I found this script to script just the triggers from a sql 2008 database: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30222/. Is that the only way to do it? Did MS really not give you a way to do it from SSMS without including the table definitions as well? I can't believe that since you would have to delete a table's data just to change how its triggers work.

Hopefully, there's a way to do this from SSMS. Otherwise, I'll see if my copy of ApexSQL will do the trick.

Thanks in advance.
LVL 1
ZekeLAAsked:
Who is Participating?
 
avirupsConnect With a Mentor Commented:
There is no other way through SSMS.
0
 
spikellyConnect With a Mentor Commented:
No way through SSMS. Check with your APEXSQL which will help you achieve this by generating a Documentation; you can try SQLDoc from Redgate.Com as well, all are great SQL tools.

0
 
Bhavesh ShahLead AnalysistCommented:
Hi Author,

SSMS is not provide any tool.but you can do achieve via query.



SELECT tl.name [Table Name],TR.Name [Trigger Name] ,EV.Type_Desc [Trigger Event],
c1.text
from sys.TRIGGERS tr
inner join sys.trigger_events ev on tr.object_id=ev.object_id
inner join SYS.OBJECTS tl on tl.object_id=tr.parent_id
INNER JOIN syscomments C1 ON tr.object_id=c1.id
order by tl.name

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.