I have an SP. which needs to be deployed to production. Am i better off
using Alter statement
or drop and recreate.
Will alter statement preserve permissions on the object?
Taken from BOL2005:
Modifies a previously created procedure that was created by executing the
CREATE PROCEDURE statement. ALTER PROCEDURE does not change permissions and
does not affect any dependent stored procedures or triggers. However, the
current session settings for QUOTED_IDENTIFIER and ANSI_NULLS are included
in the stored procedure when it is modified. If the settings are different
from those in effect when stored procedure was originally created, the
behavior of the stored procedure may change.
@yahoo.com> wrote in message