Re: why my @@servername is null?

From: hanyun (hanyun_at_diaocha.net)
Date: 06/12/04

  • Next message: Bob Simms: "Re: transactional replication for high availability" 
    Date: Sat, 12 Jun 2004 10:11:40 +0800

    Thanks, I can see the @@servername now.

    I had read the sp_xxx storeprocess.

    "Paul Ibison" <Paul.Ibison@Pygmalion.Com> дÈëÏûÏ¢
    news:u4GSqVmPEHA.3300@TK2MSFTNGP09.phx.gbl...
    > 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
    >
    >

  • Next message: Bob Simms: "Re: transactional replication for high availability"

    Relevant Pages

    • Re: why my @@servername is null?
      ... Please have a look at sysservers directly to see what entries you have ... SELECT srvid, srvname ... 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)