Post reply

export multiple SP

  • November 4, 2009 at 12:52 pm

    #211784

    Using SSMS 2005, I know how to export a single stored prod into a file. I'm Googling for a way to export all SPs in a database at once. Can this be done?

  • November 4, 2009 at 1:02 pm

    #1075013

    Into a single file or 1 file per stored proc?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • November 4, 2009 at 1:15 pm

    #1075024

    CirquedeSQLeil (11/4/2009)

    Into a single file or 1 file per stored proc?

    Either way, right click on the Database -> Tasks -> Generate Scripts

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

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