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

来源：https://www.cnblogs.com/shanzzs/p/3996485.html