SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE PROCEDURE [dbo].[OldSPName]
AS
SELECT 1 AS c;
EXEC sp_rename '[dbo].[OldSPName]','[dbo].[OldSPName_TMP]'
Caution: Changing any part of an object name could break scripts and stored procedures.

EXEC dbo.[dbo].[OldSPName_TMP]
Msg 911 Level 16 State 4 Line 1
Database 'dbo' does not exist. Make sure that the name is entered correctly.

EXEC dbo."[dbo].[OldSPName_TMP]"

c

1

DROP PROCEDURE dbo."[dbo].[OldSPName_TMP]"