首页 > 代码库 > sqlserver修改计算机名称。

sqlserver修改计算机名称。


SELECT @@SERVERNAME As [@@SERVERNAME], CAST(SERVERPROPERTY(‘MACHINENAME‘) AS VARCHAR(128)) + COALESCE(‘\‘ + CAST(SERVERPROPERTY(‘INSTANCENAME‘) AS VARCHAR(128)), ‘‘) As RealInstanceName


DECLARE @InternalInstanceName sysname;
DECLARE @MachineInstanceName sysname;

SELECT @InternalInstanceName = @@SERVERNAME, @MachineInstanceName = CAST(SERVERPROPERTY(‘MACHINENAME‘) AS VARCHAR(128)) + COALESCE(‘\‘ + CAST(SERVERPROPERTY(‘INSTANCENAME‘) AS VARCHAR(128)), ‘‘);

IF @InternalInstanceName <> @MachineInstanceName
BEGIN -- Rename the instance
EXEC sp_dropserver @InternalInstanceName;
EXEC sp_addserver @MachineInstanceName ,‘LOCAL‘
END
print @@servername

sqlserver修改计算机名称。