Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language

Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

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?


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.

"nkg" <x@yahoo.com> wrote in message


"Immy" <therealasianb@hotmail.com> wrote in message


Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc