Post reply

stored procedures in sql server 2005

  • December 13, 2007 at 2:58 am

    #179874

    how to copy existing stored procedure before updating it in sql server express management studio screen

  • December 20, 2007 at 4:00 pm

    #761942

    I am not sure if management studio is limited in SQL Express, but usually you can just Right-Click on the stored proc name and select "Script Stored Procedure As" then select "Create To" finally select an appropriate option and save the query in a good place.

    If by chance the management studio for SQL Express does not have this option, you can run this command and then save the query results somewhere.

    exec sp_helptext 'ProcedureName'

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

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