Server renamed after SQL Server installation to address issues

After SQL Server is installed, the server is renamed, causing the names to be inconsistent, using the following methods:

This action also applies to modifying the server name.

1, query the current server's old server name:

SELECT @@servername AS 旧服务器名

2, query the current server's latest server name:

SELECT serverproperty(‘servername‘) AS 新服务器名

3, if the above two server names are inconsistent, the serverproperty (' servername ') is the same, use the following statement to change the server name to the latest:

EXEC sp_dropserver  @server  = ‘旧服务器名‘EXEC sp_addserver  @server  =  ‘新服务器名‘,  @local  =  

Server renamed after SQL Server installation to address issues