Post reply

Select @@Servername returns null after reboot

  • August 18, 2005 at 11:23 am

    #152516

    After a reboot of a SQL 2000 box, a Select @@Servername returns null when it used to return the server name. I suspect that one of the SAs has used sp_addserver incorrectly and the effects are just apparent after the stop and start of SQL. Has anyone ever seen this before, or know any other reason why Select @@Servername would return null after a reboot, when if used to return the server name?

  • August 18, 2005 at 11:32 am

    #583217

    Did you try re-rebooting? I saw that as a solution to a similar problem, but I can't find the actual thread now.

  • August 18, 2005 at 11:51 am

    #583228

    We solve the problem by:

    SP_dropserver 'ABC'

    go

    sp_addServer 'ABC', 'local'

    and then stopping and restarting SQL. But this was after many things failed that relied on the @@Servername. Naturally I would like to prevent this from happening again.

  • August 18, 2005 at 11:58 am

    #583234

    Glad to hear that. Maybe you should drop a line to the other DBAs, maybe that'll ring a bell for something they did in the last x months.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply