Publications problem

[surzycki]

Got a strange problem here.

When I tried to create new publications on my SQL 7, the error message
poped up stating the @@SERVERNAME is null, use sp_addserver to set it up.

When I used the sp and drop the server then add the server, still the same error pops up... I have several SQL servers, all the others would allow me to create a new publication, except for that I don't want to use them.

Any ideas?


Stefan

 

[JamesLean]

You need to run sp_addserver with the @local parameter. You then need to restart the server to update @@SERVERNAME.

Look up sp_addserver in BOL for a full explanation.

--James