突触存储过程中用于sp_rename的参数数不足

问：

我在 Synapse 专用 sql 池中有此存储过程，该存储过程正在将临时表重命名为主表。

ALTER PROCEDURE [dbo].[RenameStagingTableToDedicatedTable]
(

    @DedicatedTableName VARCHAR(MAX)
)
AS
BEGIN
    -- Check if the Dedicated table exists
    IF EXISTS (SELECT 1 FROM sys.objects WHERE type = 'U' AND name = @DedicatedTableName)
    BEGIN
        -- Rename the staging table to the Dedicated table
        EXEC sp_rename 'gold.Service_Staging', 'gold.Service'
 
        -- Drop the existing Dedicated table
        EXEC ('DROP TABLE ' + @DedicatedTableName)
    END
    ELSE
    BEGIN
        -- The Dedicated table does not exist, so rename the staging table to the Dedicated table
        EXEC sp_rename 'gold.Service_Staging', 'gold.Service'
 
    END
END
GO

执行此存储过程时，出现以下错误：

为过程或函数提供的参数数量不足sp_rename

有什么想法为什么吗？