How to Script all Triggers from DB into Text File?

Question

How to Script all Triggers from DB into Text File?

Abrar Ahmad_

SSCarpal Tunnel

Points: 4244
More actions
August 12, 2010 at 5:38 am

#226017

[font="Verdana"]:unsure:
How to script triggers only and getting output in text files as same as SSMS Script Wizard, specially w.r.t SQL Server 2005 and 2008.
[/font]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30222/

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Abrar Ahmad_ SSCarpal Tunnel Points: 4244 More actions · Answer 2

skcadavre (8/12/2010)
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30222/

[font="Verdana"]Thank you for your time,

but i had gone through this solution before but .... !

My scheme would be to replace this old technique, as we can easily get definition of trigger by new methods into a table/variable and then by just using any useful/simple technique to write contents of that table/variable to a simple text file.

Do you can assist? Please!

[/font]

Jagdev Mr or Mrs. 500 Points: 552 More actions · Answer 3

Did you got any script which will generate all triggers in separate files. I have 781 triggers to be scripted out. The solution given in link does not create separate files for each trigger.

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 4

Jagdev, post a new thread and detail your issue a little more.

People don't tend to respond to older threads.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.