select @@servername (results NULL) 1

[karbon]

Hi every one.
I have to SQLServers in my computer.
First one SQL Server 7.0 (CEM)
Second one SQL Server 2000 (CEM\SQL2)

When use (select @@servername) in sql2000
Result : CEM\SQL2

But When use (select @@servername) in sql7
Result : NULL

There is no problem when i connect Query Analy. Or Enterprise Manager.
In Enterprise Manager I see both of them with their correct name. CEM and CEM\SQL2

How can i get my @@servername back?....
Where is it recorded? Registry? SQL systemtables?

 

[nigelrivett]

see sp_addserver

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[karbon]

Thank You very much. I found in sysservers that CEM srvID was 6. But it must be 0 in order to be local server name.

This solved my problem.

sp_dropserver 'CEM'
sp_addserver 'CEM', 'local'
Stop and Start SQL Server.


thanks again.

 

[gashandler]

Fixed my problem too. Thanks!!