Re: why my @@servername is null?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Aju (ajuonline_at_yahoo.com)
Date: 05/20/04 

Date: Thu, 20 May 2004 17:39:12 +0530

Hi ,
Just to update
I tried to test it .
It worked in reverse way now I can't see @@servername
null is coming .

Ajay

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:9815A60B-A884-42FE-9C0C-74C15CE8F883@microsoft.com...
> Hanyun,
> try running the following script to reset the sysservers entry:
> Use Master
> go
> Sp_DropServer 'Server1'
> GO
> Use Master
> go
> Sp_Addserver 'Server1', 'local'
> GO
> Stop and Start SQL Services
>
> Regards,
> Paul Ibison

Relevant Pages

  • Re: Move databases between servers
    ... SELECT @@servername ... What I'm trying to do now is to copy master. ... Now I'm reinstalling sql with identical version, and restore all databases ...
    (microsoft.public.sqlserver.setup)
  • Re: Move databases between servers
    ... Did you read the section within Books Online for restoring master? ... General network error. ... I checked the servername and it's still the old one. ...
    (microsoft.public.sqlserver.setup)
  • Re: Distributor
    ... this could be a naming issue. ... Use Master ... Select @@Servername ... Sp_Addserver 'XServer', 'local' ...
    (microsoft.public.sqlserver.replication)
  • Re: 14114 error
    ... After executing ur instruction i still get 'null' as the local servername. ... > Use Master ...
    (microsoft.public.sqlserver.replication)