Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

stored procedures in sql server 2005 Expand / Collapse
Author
Message
Posted Thursday, December 13, 2007 2:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 3, 2008 5:14 AM
Points: 2, Visits: 10
how to copy existing stored procedure before updating it in sql server express management studio screen
Post #432724
Posted Thursday, December 20, 2007 4:00 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 30, 2014 5:41 PM
Points: 81, Visits: 179
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'

Post #435430
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse