Post reply

@@servername

  • August 26, 2005 at 8:26 am

    #152525

    Hi,

     When I use the @@servername, I am getting null as result. Do you have any idea why this is happening.

  • August 26, 2005 at 8:33 am

    #585443

    Did you run sp_dropserver?

    Did you restart the service/server?

  • August 26, 2005 at 8:36 am

    #585448

    No, I did not run that SP but when I tried to use the sp_addserver, it says server already exists in that name.

  • August 26, 2005 at 8:38 am

    #585449

    That can't be good, can you restart the service (and the server if that doesn't work)?

  • August 26, 2005 at 12:11 pm

    #585547

    I'd take Remi's advice and drop the server, then add it back in:

    EXEC sp_dropserver 'yourServerName'

    EXEC sp_addserver 'yourServerName', 'local'

    Stop SQL Server.

    Restart SQL Server.

    Also, try either or both of these:

    EXEC sp_helpserver

    and

    SELECT srvid

         , srvname

         , datasource

         , srvnetname

     FROM master..sysservers

    Do the results look correct?

     

     

  • August 26, 2005 at 2:20 pm

    #585609

    Works great thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

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