Script Search

  • 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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

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