NathanGriffiths
Programmer
When I query the global variable which is supposed to contain the name of the local SQL Server e.g.
SELECT @@servername
it returns NULL instead of the server name. This is supposed to be set during installation.
According to BOL I should be able to change the local server name using
sp_addserver '<servername>','local'
However, when I do this I get an error message saying '<servername>' already exists. Anyone know what's going on?
thanks,
Nathan
SELECT @@servername
it returns NULL instead of the server name. This is supposed to be set during installation.
According to BOL I should be able to change the local server name using
sp_addserver '<servername>','local'
However, when I do this I get an error message saying '<servername>' already exists. Anyone know what's going on?
thanks,
Nathan