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

modify and restore the stored procedure in sql server 2005 express studio Expand / Collapse
Author
Message
Posted Thursday, December 20, 2007 10:18 PM
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
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 »

Add to briefcase

Permissions Expand / Collapse