Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script Search Expand / Collapse
Author
Message
Posted Thursday, April 30, 2009 8:28 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, May 10, 2013 6:46 AM
Points: 86, Visits: 145
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
Post #707721
Posted Thursday, April 30, 2009 10:49 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:47 AM
Points: 41,525, Visits: 34,442
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #707840
Posted Thursday, April 30, 2009 3:30 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:29 PM
Points: 11,168, Visits: 10,928
john (4/30/2009)
Forgive me for the xpost. I only hit this and administration.

Oh well that's ok then!

At least you didn't cross-post above the allowable of maximum of...hey...where is that dividing line?

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
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #708104
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse