April 30, 2009 at 8:28 am
Forgive me for the xpost. I only hit this and administration.
I was wondering if anyone has a script that can take a DB name as input and dump out all of the stored procedures to disk files for backup purpose.
I would like to be able to do this and then I can post the SPs to our subversion. If no one has this I will write it and share it here but thought I would check first.
Thanks in advance
JD
April 30, 2009 at 10:49 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic707717-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2009 at 3:30 pm
john (4/30/2009)
Forgive me for the xpost. I only hit this and administration.
Oh well that's ok then! :doze:
At least you didn't cross-post above the allowable of maximum of...hey...where is that dividing line? :laugh:
It's good to see that you have discovered how much more efficient it is to just post your workload on here rather than, say, searching the site or using Google.
Have another cup of coffee, put your feet up, and let me take care of this for you:
http://lmgtfy.com/?q=site:www.sqlservercentral.com:sql+server+script+stored+procedures
With thanks to Lynn for the link idea
edit: fixed broken tinyurl
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply