SQL Server replication requires an actual server name to connect to the server _mssql

The problem that I ran into today when I was doing the SQL Server 2005 experiment was that the problem description was clear, and I suspected that I had changed the name to the computer before. You can use the SELECT @ @servername and select SERVERPROPERTY (' ServerName ') In contrast, two results are the same, the problem will not be the same, the following given the solution of the SQL script

Copy Code code as follows:

If SERVERPROPERTY (' servername ') <> @ @servername
Begin
declare @server sysname
Set @server = @ @servername
exec sp_dropserver @server = @server
Set @server = Cast (serverproperty (' servername ') as sysname)
exec sp_addserver @server = @server, @local = ' local '
End

After execution, the problem can be solved by re-SQL