Re: @@servername

From: Immy (imtiaz_ullah_at_hotmail.com)
Date: 03/04/04 

Date: Thu, 4 Mar 2004 12:21:24 -0000

  Ricardo,

  If the server has been renamed in the past whilst SQL was installed, then
the @@servername will be wrong.
  In order to resolve it, do the following.

  SP_DROPSERVER OLDSERVERNAME
  GO
  SP_ADDSERVER CORRCECTSERVERNAME, LOCAL
  GO

  Then you must restart SQL server to take effect.

  Immy

  "Ricardo" <anonymous@discussions.microsoft.com> wrote in message
news:F29CD1CA-3752-4B2F-97E9-CF6BE4FF10EB@microsoft.com...
> If I try this
>
> SELECT @@servername
>
> In Query Analyzer, I get a servername other than mine (I'm connected to
localhost)
>
> What's happening?
>
> Thanks
> Ricardo

Relevant Pages

  • Re: terminal services licensing
    ... > server afterwards, i did a bit of digging around but haven't tried it yet. ... >> I've never add the TS licensing the server after the OS install, ... >> Ricardo M. Urbano ...
    (microsoft.public.windows.server.general)
  • Re: Migration from w2k3 DC to another w2k3 (hardware)
    ... I forgot mention that I have DHCP, DNS and WINS server on the DC. ... Ricardo Lopez ... Transfer FSMO to new DC ... > Vincent Xu ...
    (microsoft.public.windows.server.migration)
  • Re: Built-in W2K3 groups
    ... Stand-alone Server) that each built-in group have? ... > Hi Ricardo, ... > defined in Active Directory on domain controllers. ...
    (microsoft.public.windows.server.general)
  • Re: bruteforce ssh
    ... Ricardo wrote: ... > How can I block IP adresses that trying to a Bruteforce atack on my server? ...
    (comp.security.ssh)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)