Can''t Alter Proc

• dean gross

  SSCrazy

  Points: 2632

  More actions

  January 28, 2005 at 8:57 am

  #163712

  In QA when I right click on one of my procs and select edit, I am getting a Create Proc statement instead of an Alter Proc. This does not happen for other procs. What would cause this and how can I fix? Scipting an Alter to a new window has the same result. I don't have the proc open in another window and the Process info window shows me that there are not any other users in the db

• hoo-t

  SSChampion

  Points: 12713

  More actions

  January 28, 2005 at 3:09 pm

  #539625

  I'm not sure why its happening, but all you need to do is change the word CREATE to ALTER.

  Steve