Issues and workarounds for changing computer names after SQL Server installation

Use mastergodeclare @serverproperty_servername varchar, @servername varchar (100)--Gets the Windows NT server and with the specified SQL server Instance information associated with instances--can be seen in Books Online "Serverproperty" Select @serverproperty_servername = CONVERT (varchar), serverproperty (' ServerName ')--Returns the name of the local server running Microsoft®sql Server™-see Books Online @ @SERVERNAMESELECT @servername = CONVERT (varchar (100), @ @SERVERNAME)--if @serverproperty_servername and @servername are different (because you changed the computer name), run the following select @serverproperty_ Servernameselect @servername--Remove the wrong server name exec sp_dropserver @[email protected]--Add the correct server name exec sp_addserver @[email Protected]_servername, @local = ' local '

　　

Issues and workarounds for changing computer names after SQL Server installation