If I run the store procedures sp_dropserver and sp_addserver, will it affect current users in anyway? Should I do this after hour? I ran the sp_helpserver on the publisher and its name was corrected but the ID was set at 1 instead of 0.
Thank You for your help.
----- Shirley Kelly [MS] wrote: -----
Run sp_helpserver on the publisher. Verify that the ID for the local
server is 0. Verify that the name of the server is correct. If either of
this is wrong, run these commands to correct the problem:
sp_dropserver "servername", droplogins
sp_addserver 'servername', local
Then you should be able to enable the server as a publisher.
Shirley Kelly, MCSE, MCDBA
Microsoft SQL Server Support
This posting is provided â€śAS ISâ€ť with no warranties, and confers no rights.
You assume all risk for your use. Â© 2001 Microsoft Corporation. All rights
reserved. >> Stay informed about: Publishing Database error