SQL Replication (@@ServerName)
Posted on 2001-08-16
Hello I am getting the following error trying to work with replication between 2 SQL servers.
By the way, I am not sure if this matters but i want the distributor to be SQL 7 and the client to be
The error i am getting is:
SQL Server Enterprise Manager could not complete the wizard because @@SERVERNAME for '' is NULL.
Use sp_AddServer to set @@ServerName
By the way, I tried to execute sp_AddServer and restarted the server but did not work. This is What
Exec sp_AddServer 'MyServer'
It did not return any error. But it did not help.