• raj.prabhu001 (9/30/2013)


    hi all,

    i want to create a script to backup the stored procs of the database plz suggest.

    If this is a one time deal, you can use Management Studio and script those out. Just right click the database, then Task, then Generate Scripts, then select the objects, on this case, store procedures. Then save locally or decide if you want a script per object or a single master script.