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?

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...

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

news:eueN0E4pHHA.588@TK2MSFTNGP06.phx.gbl...

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