用toad for sql server 之后发现
可用下面这段代码去rename一个存储过程
-- Renamed to viewfocus.dbo.P_DSS_SynrDeviceData_old_1
USE [viewfocus];GO
EXEC sys.sp_rename @objname = N'[dbo].[P_DSS_SynrDeviceData_old]', @newname = N'P_DSS_SynrDeviceData_old_1', @objtype = N'OBJECT';
GO