August 12, 2010 at 5:38 am
[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]
August 12, 2010 at 7:52 am
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30222/
August 12, 2010 at 10:43 pm
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]
November 20, 2015 at 4:45 am
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.
November 23, 2015 at 7:03 am
Jagdev, post a new thread and detail your issue a little more.
People don't tend to respond to older threads.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy