Modify a Stored Procedure using SQL Server Management Studio

1. In the Object Explorer, connect to an instance of the Database Engine and then expand that instance.

2. Expand Databases, Expand the database in which the procedure belongs, and then Expand programmability .

3. Expand Stored Procedures, right-click the procedure to modify, and then click Modify.

4. Modify the text of the stored procedure.

5. To test the syntax, on the Query menu, click Parse.

6. To save the modifications to the procedure definition, on the Query menu, click Execute.

Modify a Stored Procedure using SQL Server Management Studio