Post reply

@@servername null?

  • January 22, 2004 at 10:59 am

    #84138

    if I use sp_helpserver it gives me the correct name, but a null if I use @@servername. SO i then try sp_drop and sp_rename and still get null? 

    Is there another option besides reloading sql?

  • January 22, 2004 at 11:08 am

    #491175

    Run sp_addserver.

  • January 22, 2004 at 11:15 am

    #491180

    tried that already says it exsists. so I then rerun @@servername and it still says null no makes no since

  • January 22, 2004 at 11:22 am

    #491183

    Try sp_addserver 'yourservername', 'local' and restart SQL Server.

  • January 22, 2004 at 11:26 am

    #491186

    tryied that to, got it already exists.Then I run @@servername and its 'null'? makes no since

  • January 22, 2004 at 11:27 am

    #491187

    1. Drop it by sp_dropserver

    2. Restart SQL Server

    3. Add it back by sp_addserver 'servername', 'local'

    4. Restart SQL Server

    5. select @@servername

  • January 22, 2004 at 11:34 am

    #491188

    tried that yesterday,didn't work.

    I tried again for the hell of it and IT WORKED

    SWEEEEET !!!!! I think I left of the 'local'

  • January 22, 2004 at 3:46 pm

    #491236

    Check your version of Books Online. If you have the one that shipped with SQL Server, I believe it left off the local. That's been fixed, along with a slew of other things in the last two versions of BOL. To get the most recent version, go here:

    http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

     

    K. Brian Kelley
    @kbriankelley

  • January 26, 2004 at 7:14 am

    #491599

    install SP3a for Sql Server 2000 ... and do all the above steps again


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

Viewing 9 posts - 1 through 8 (of 8 total)

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