dakshinamurthy-655138
SSCertifiable
Points: 5172
More actions
June 19, 2008 at 9:48 am
#72335
Hi,
I need to take the script of all the store procedures and write into a file frequently via SQL Server 2000 job, will you please let me know how to go with this.
Dakshina
Steve Jones - SSC Editor
SSC Guru
Points: 736162
June 19, 2008 at 11:32 am
#831282
do you mean you want to schedule this? You can right click in EM and script things out.
If you want this on a schedule, you'll need some DMO automation.
http://www.sqlservercentral.com/articles/1084/
June 19, 2008 at 10:12 pm
#831472
Yes I would like to schedule this, how to go with this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply