Post reply

How do i script my stored procedures?

  • January 27, 2004 at 7:49 am

    #76115

    Guys,

      We have about 30 stored procedures in our database (Sql server 2000). I wish to script all the stored procedures so that i can re-generate them at will. How do i do this? I can do one at a time by right clicking and saving the stored procedure as scripts but i wish to script all 30 off them at the same time.

  • January 27, 2004 at 8:01 am

    #491760

    In EM, right-click on the db in question, select All tasks, Generate SQL script, select 'Show all', check 'All Stored Procedures. Then choose the other option you'd like, and there you go.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 27, 2004 at 8:04 am

    #491761

    Thanks. I found the option once i posted my message out here. Your timely response is appreciated.

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

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