modify and restore the stored procedure in sql server 2005 express studio

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 » modify and restore the stored procedure in...

modify and restore the stored procedure in sql server 2005 express studio

Rate Topic

Display Mode

Topic Options

Author

Message

vaduguru.sankar

Posted Thursday, December 20, 2007 10:18 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 03, 2008 5:14 AM
Points: 2, Visits: 10

thanks for sending reply.
I understood.
Iam new to stored procedure in sql server 2005. (express management studio)

In my project , I need to perform following steps.

1) extract and save the existing stored procedure (some sp_x) from dev database.back up the code for this stored procedure.
2) extract and open the attached file(c:\home\bpmi\sp_x_new) in an editor
3) do some modificationsin that code
4)save and execute the code to alter the stored procedure.
5) verify that stored procedure sp_x reflects the changes which i have made.(how to compare existing sp and modified sp by keeping two in editor)

so My Request is how to do the steps in order.

Post #435479

« Prev Topic | Next Topic »

Permissions