Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

@@servername Expand / Collapse
Author
Message
Posted Wednesday, November 23, 2005 9:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 8, 2008 8:27 AM
Points: 175, Visits: 5

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.

Post #239210
Posted Wednesday, November 23, 2005 1:24 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:34 AM
Points: 6,259, Visits: 2,031

did you restart the server ?

 




* Noel
Post #239278
Posted Thursday, November 24, 2005 12:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 8, 2008 8:27 AM
Points: 175, Visits: 5

Yes I did.

After restart @@servername shows 'SECONDNAME', but

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

Post #239370
Posted Thursday, November 24, 2005 12:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:56 AM
Points: 6,748, Visits: 8,545

did you also alter the physical servers name ?

 



Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #239374
Posted Thursday, November 24, 2005 2:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 8, 2008 8:27 AM
Points: 175, Visits: 5

I did only sp_dropserver 'FIRSTNAME'

and sp_addserver 'SECONDNAME', LOCAL.

Nothing else.

I wonder where serverproperty('servername') gather information

Post #239398
Posted Thursday, November 24, 2005 2:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:56 AM
Points: 6,748, Visits: 8,545

don't mess with systemtables  

but how about :

select *
from master.dbo.sysservers



Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #239399
Posted Monday, November 28, 2005 1:03 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:44 PM
Points: 3,221, Visits: 2,375
Could you post the output of sp_helpserver ?



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #240091
Posted Monday, November 28, 2005 1:23 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 8, 2008 8:27 AM
Points: 175, Visits: 5
sp_helpserver gives me SECONDNAME
Post #240101
Posted Monday, November 28, 2005 1:50 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:44 PM
Points: 3,221, Visits: 2,375
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 ...



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #240113
Posted Tuesday, November 29, 2005 2:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 8, 2008 8:27 AM
Points: 175, Visits: 5

name                         secondname

network_name           secondname

status                         rpc,rpc out,use remote collation     

id                               0

collation_name           NULL

connect_timeout         0

query_timeout            0

 

Post #240261
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse