Home Forums SQL Server 2005 Backups Backing up multiple stored procedures into individual text files RE: Backing up multiple stored procedures into individual text files

  • December 14, 2007 at 9:40 am

    #760340

    Karthik (12/14/2007)

    [font="Verdana"]Right click on the database in SSMS. Go to Tasks->Generate Scripts.

    Go with the defaults in the wizard till you come to the page to select object types. Select Stored Procedures. In the next screen, select Script to File -> File Per Object.

    Hopefully this is what you needed![/font]

    SWEET! This is exactly what I was looking for. My only problem was that I was trying it from my client machine and I couldn't find the 'File per Object' option. Then I logged into the DB server and there it was...

    Muchas Gracias Senor!:w00t: