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

How to: Delete a Stored Procedure (SQL Server Management Studio)

New: 5 December 2005

This topic describes how to delete a stored procedure by using Object Explorer in SQL Server Management Studio.

ms345358.note(en-US,SQL.90).gifImportant:
Deleting a stored procedure can cause dependent objects and scripts to fail when the objects and scripts are not updated to reflect the changes that have been made to the stored procedure. For more information, see How to: View the Dependencies of a Stored Procedure (SQL Server Management Studio).

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

  2. Expand Databases, expand the database in which the stored procedure belongs, and then expand Programmability.

  3. Expand Stored Procedures, right-click the procedure to remove, and then click Delete.

  4. To view objects that depend on the stored procedure, click Show Dependencies.

  5. Confirm the correct stored procedure is selected, and then click OK.

  6. Remove the stored procedure name from dependent objects and scripts.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.