Post reply

SQL 2000 @@REMSERVER problem

  • January 18, 2016 at 8:50 am

    #100215

    I am having a problem on a SQL 2000 machine (Yes I know it is really old :-D) When using the @@REMSERVER on 4 of 5 servers it returns the machine value. When I do it on the 5th machine it sends back a NULL. Our DOS Mexico systems use it when tracking information from workstations for efficiency.

    Does anyone remember how to fix the @@REMSERVER problem of NULL

    Thanks

    Jim Pecora

    P.S. it is SQL 2000 CU3

  • January 18, 2016 at 10:39 am

    #1852547

    Not sure if it is related or not, but perhaps this helps:

    https://support.microsoft.com/en-us/kb/303774

    (This is about @@SERVERNAME, not about @@REMSERVER - but have you tested @@SERVERNAME on both the local and the remote server? Perhaps [shooting in the dark here] your problem is related to the NULL @@SERVERNAME issue?)

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • January 20, 2016 at 6:57 am

    #1853121

    Thanks for the quick response Hugo.

    I have checked @@SERVERNAME and it is working fine. I am wondering if you may know where the @@REMSERVER pulls the name from? Is it in a location I can get to? Any other ideas would be great.

    Again Thanks for the help

    Jim P

  • January 20, 2016 at 7:46 am

    #1853141

    Unfortunately, I have absolutely no clue where @@REMSERVER takes its name from. I am sorry to not be of more help. 🙁

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • January 20, 2016 at 7:53 am

    #1853147

    No problem. Thanks for trying.

    Anyone else have any clue about @@REMSERVER returning NULL

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

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