Export (0) Print
Expand All
3 out of 3 rated this helpful - Rate this topic

Modifying Stored Procedures

If you need to change the statements or parameters in a stored procedure, you can either delete and re-create the stored procedure or alter the stored procedure in a single step. When you delete and re-create a stored procedure, all permissions associated with the stored procedure are lost. When you alter the stored procedure, the procedure or parameter definition is changed but the permissions defined for the stored procedure are retained and any dependent stored procedures or triggers are not affected.

A stored procedure can also be modified to encrypt the definition or cause the procedure to be recompiled each time it is executed.

NoteNote

Changing the name or definition of a stored procedure can cause any dependent objects to fail when executed if those dependent objects are not also updated to reflect the changes made to the stored procedure.

To modify a stored procedure

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.