Post reply

Dump procedures to disk

  • September 13, 2010 at 3:55 pm

    #140656

    SQL Server 2000 used to have a utility to dump all of the procedures to disk in either a single file or individual files along with adding CREATE and DROP statements. I need to create copies of all of the procedures in my SQL Server 2005 database in order to load them into Clearcase. Is there a way to do this simply in SQL Server 2005?

  • September 13, 2010 at 4:09 pm

    #1220350

    Right click the db, Tasks, Generate Scripts.

    You can script the stored procedures from here with many options.

  • September 13, 2010 at 4:10 pm

    #1220352

    Ahhhh That is where MS hid it. Thanks very much

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

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