Results 1 to 3 of 3

Thread: @@servername

  1. #1
    Join Date
    May 2002
    Location
    New York
    Posts
    35

    Angry Unanswered: @@servername

    If anybody can explain why for one of my SQL Server2000 servers the statement select @@servername returns NULL instead of name?
    Thanks

  2. #2
    Join Date
    Aug 2006
    Location
    San Francisco, CA
    Posts
    136
    The BOL is incomplete about this subject. Try this microsoft article

    Good luck
    Hope this helped

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd use:
    Code:
    EXECUTE sp_addserver 'desiredServerName', 'LOCAL'
    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •