@@servername returns to Null after reboot

• rilke

  Grasshopper

  Points: 24

  More actions

  January 10, 2003 at 2:40 pm

  #159399

  I have a w2k server running SQL Server 7. This server is a replication distributor. After a reboot, @@servername becomes null, which pretty much requires me to blow away replication fix @@servername and set up replication from scratch. However, another reboot causes the problem all over again.

  HELP. Not sure what I'm missing here. Any suggestions at all are appreciated.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  January 10, 2003 at 4:52 pm

  #446112

  When it happens, what do you have listed in sysservers? Can you pinpoint what happened prior to the problem beginning? Why is it tied to replication?

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter