Re: why my @@servername is null?

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 05/20/04


Date: Thu, 20 May 2004 13:22:55 +0100

Aju,
did you restart the services?
Please have a look at sysservers directly to see what entries you have
there:

SELECT srvid, srvname
FROM master.dbo.sysservers

Do you get your servername back with a srvid of zero? If not then run the
script in my other post again.

HTH,
Paul Ibison



Relevant Pages

  • Re: why my @@servername is null?
    ... > did you restart the services? ... > Please have a look at sysservers directly to see what entries you have ... > Do you get your servername back with a srvid of zero? ...
    (microsoft.public.sqlserver.replication)
  • Re: sysxlogins table with entries
    ... Thanks Sue, I looked in sysservers and the srvid of course is the ... then the 2 and 3 are entries due to links..thks ...
    (microsoft.public.sqlserver.security)