變更 Instance Name
發表於 : 2016-09-12 12:20:07
查詢
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
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