george sibbald (2/27/2014)
below86 (2/27/2014)
I have often said I avoid stored procedures for the most part. But this too has always seemed odd to me. You are essentially replacing the entire code when you do the ALTER PROCEDURE, so why not drop the procedure and do a create?because you lose the permissions granted to the stored proc that way.
...
I always thought that the two ALTERs were semantically different and, therefore, shouldn't share the command.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!