變更 Instance Name

[schumi]

查詢
SELECT @@SERVERNAME AS old_name,
CAST(SERVERPROPERTY('MACHINENAME') AS VARCHAR(128)) + COALESCE('\' + CAST(SERVERPROPERTY('INSTANCENAME') AS VARCHAR(128)), '') AS new_name;

變更
exec sp_dropserver 'VM1'
go
exec sp_addserver 'VM2','local'
go