修改计算机名sql修改吗,sqlserver修改计算机名称。

最新推荐文章于 2024-04-20 19:06:08 发布

波拿拿

最新推荐文章于 2024-04-20 19:06:08 发布

阅读量243

点赞数

文章标签：修改计算机名sql修改吗

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