How to delete a stored procedure (Enterprise Manager)

To delete a stored procedure

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the stored procedure belongs, and then click Stored Procedures.
3. In the details pane, right-click the stored procedure to delete, and then click Delete.
4. To see how deleting this stored procedure will affect the database, click Show Dependencies....
5. Click Drop All.

See Also

Deleting a Stored Procedure