Server property

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi,

when try to run this command(select @@servername) to look my server name, showing NULL. I tried with sp_addserver 'New name', 'local' and restared my Server still it is showing server name is NULL.

In sysservers table i can see my server name. How can i change the NULL to my server name.

Thanks, Ravi.

-- Anonymous, January 07, 2002

Answers

Ravi,

Try:

sp_dropserver NEWNAME

reboot

sp_addserver NEWNAME, LOCAL

reboot

select @@servername

Hope this helps,

Eric

-- Anonymous, January 07, 2002


Moderation questions? read the FAQ