Server propertygreenspun.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
Ravi,Try:
sp_dropserver NEWNAME
reboot
sp_addserver NEWNAME, LOCAL
reboot
select @@servername
Hope this helps,
Eric
-- Anonymous, January 07, 2002