SQLServerCentral / Administration / SQL Server 7,2000 / @@servername / Latest Posts

RE: @@servername

rudy - Doctor "X" — Wed, 30 Nov 2005 15:24:00 GMT

Thanks for the information Yelana !

RE: @@servername

Yelena Varshal — Wed, 30 Nov 2005 15:11:00 GMT

They should report different names in some cases. See Books Online @@Servername topic:

"......

Although the @@SERVERNAME function and the SERVERNAME property of SERVERPROPERTY function may return strings with similar formats, the information can be different. The SERVERNAME property automatically reports changes in the network name of the computer.

In contrast, @@SERVERNAME does not report such changes. @@SERVERNAME reports changes made to the local server name using the sp_addserver or sp_dropserver stored procedure..........."

RE: @@servername

rudy - Doctor "X" — Wed, 30 Nov 2005 15:07:00 GMT

I was able to duplicate your issue on a named instance. I need to acquire a 'default' instance yet ...

RE: @@servername

Momak — Tue, 29 Nov 2005 02:15:00 GMT

name secondname

network_name secondname

status rpc,rpc out,use remote collation

id 0

collation_name NULL

connect_timeout 0

query_timeout 0

RE: @@servername

rudy - Doctor "X" — Mon, 28 Nov 2005 13:50:00 GMT

Could you post the output of sp_helpserver ? (the actual results set when you execute it from QA) ... I'm asking for a specific reason, to help you figure this out ... the exact output friom a QA session (all columns) is invaluable at times ...

RE: @@servername

Momak — Mon, 28 Nov 2005 13:23:00 GMT

sp_helpserver gives me SECONDNAME

RE: @@servername

rudy - Doctor "X" — Mon, 28 Nov 2005 13:03:00 GMT

Could you post the output of sp_helpserver ?

RE: @@servername

ALZDBA — Thu, 24 Nov 2005 02:39:00 GMT

don't mess with systemtables

but how about :

select *from master.dbo.sysservers

RE: @@servername

Momak — Thu, 24 Nov 2005 02:34:00 GMT

I did only sp_dropserver 'FIRSTNAME'

and sp_addserver 'SECONDNAME', LOCAL.

Nothing else.

I wonder where serverproperty('servername') gather information

RE: @@servername

ALZDBA — Thu, 24 Nov 2005 00:26:00 GMT

did you also alter the physical servers name ?

RE: @@servername

Momak — Thu, 24 Nov 2005 00:03:00 GMT

Yes I did.

After restart @@servername shows 'SECONDNAME', but

select serverproperty('servername') shows 'FIRSTNAME'. So, it must be written somewhere that 'FIRSTNAME'.

RE: @@servername

noeld — Wed, 23 Nov 2005 13:24:00 GMT

did you restart the server ?

@@servername

Momak — Wed, 23 Nov 2005 09:49:00 GMT

Hello,my SQL Server was installed with name 'FIRSTNAME'. After that I change its name into 'SECONDNAME', with :sp_dropserver 'FIRSTNAME' sp_addserver 'SECONDNAME', LOCAL.

But when I start:select serverproperty('servername')

result is: 'FIRSTNAME'.

Wherefrom serverproperty('servername') takes information.