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.