If you have an existing procedure that you don't want to use it anymore, you should delete it from the SQL Server by using the "DROP PROCEDURE" statement as shown in the tutorial example below:

USE GlobalGuideLineDatabase;

GO

DROP PROCEDURE datetime;

GO

Command(s) completed successfully.

SELECT * FROM sys.procedures;

GO

Name  object_id schema_id type type_desc   

---------- ----------- ----------- ---- --------------------

Hello 1621580815 1   P SQL_STORED_PROCEDURE

date  1653580929 1   P SQL_STORED_PROCEDURE

(2 row(s) affected)

Stored procedure "datetime" is no longer in the database.