Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Unnamed server error

Author  Topic 

srad
Starting Member

39 Posts

Posted - 2002-01-23 : 05:11:14
On one of our SQL7.0 Servers there's an entry in the error log 'Server is unnamed'. When you execute SELECT @@servername
you get NULL.

Any ideas??

nr
SQLTeam MVY

12543 Posts

Posted - 2002-01-23 : 05:56:39
Does the machine name have a hyphen or some other strange character in it?


==========================================
Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.
Go to Top of Page

skweeky
Starting Member

9 Posts

Posted - 2002-01-23 : 06:18:03
hi from france !

try
sp_addserver 'name of your server', 'local'

maybe you must restart sql
then you will get value from @@servername

nico

Go to Top of Page
   

- Advertisement -