Can''t Alter Proc

  • 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

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

    Steve

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply