Help needed on @@SERVERNAME in SQLServer

[RamHardikar]

Hi,

we are trying to replicate our existing database onto the backup server.
when i run the wizard to create publication it says " @@SERVERNAME is NULL . Use sp_addserver to add the server".

we have tried the following option -

started SQL server in minimal configuration using 'sqlservr -f' and tried to execute sp_addserver and then restarted the sqlserver. now we executed 'select @@servername', the result was null. i also tried to execute sp_dropserver before doing the above operation. but still same result.
Pls help

Thanks in advance
Ram

 

[tlbroadbent]

Did you use the 'Local' option when executing sp_addserver?

--Drop server from list
sp_dropserver 'ServerName'
go

--Add Server as 'LOCAL'
sp_addserver 'ServerName','LOCAL'
Go

--View info about server
exec sp_helpserver
go Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[aalmeida]

I would tell you to first "exec sp_helpserver go"
If the server you are looking for has an "id" other than "0"
then could do
--Drop server from list
sp_dropserver 'ServerName'
go

--Add Server as 'LOCAL'
sp_addserver 'ServerName','LOCAL'
Go

** Now you must restart SQL Server

--View info about server
exec sp_helpserver
go

But if does not exists then you can

--Add Server as 'LOCAL'
sp_addserver 'ServerName','LOCAL'
Go

** Now you must restart SQL Server

--View info about server
exec sp_helpserver
go
AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[RamHardikar]

Thanks.. It worked...

Ram