stored procedures in sql server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Kathi Kellenberger » stored procedures in sql server 2005

stored procedures in sql server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

vaduguru.sankar

Posted Thursday, December 13, 2007 2:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 03, 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

rlvantrease

Posted Thursday, December 20, 2007 4:00 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 6:58 AM
Points: 81, Visits: 161

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 »

Permissions