InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 03:47:03 GMT20http://www.sqlservercentral.com/Forums/Topic435479-202-1.aspxthanks 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 editor3) do some modificationsin that code4)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.Thu, 20 Dec 2007 22:18:34 GMTvaduguru.sankar