Sql Server Programming :: Alter statement


	Alter statement 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? thx Taken from BOL2005: ALTER PROCEDURE 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. "nkg" <x@yahoo.com> wrote in message news:%23ZqAjA4pHHA.3952@TK2MSFTNGP03.phx.gbl... - Hide quoted text - >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? > thx thx "Immy" <therealasianb@hotmail.com> wrote in message news:eueN0E4pHHA.588@TK2MSFTNGP06.phx.gbl... - Hide quoted text - > Taken from BOL2005: > ALTER PROCEDURE > 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. > "nkg" <x@yahoo.com> wrote in message > news:%23ZqAjA4pHHA.3952@TK2MSFTNGP03.phx.gbl... >>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? >> thx