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

Rename SQL server Server Expand / Collapse
Author
Message
Posted Tuesday, August 24, 2010 1:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 28, 2012 3:18 AM
Points: 45, Visits: 394
Good Day,
We are running SQL Server 2005 on WIndows 2003 . We renamed the servername on the Operating System and a few seconds later I detected that the name in SQL Server was also changed . Does this now suggest that sp_dropserver and sp_addserver are now obsolete ? Any ideas ?

Thanks .
Post #973894
Posted Tuesday, August 24, 2010 1:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, October 31, 2014 11:06 AM
Points: 5,430, Visits: 10,108
If you run SELECT [name] FROM sys.servers, do you see the old server name, or the new one?

John
Post #973897
Posted Tuesday, August 24, 2010 2:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 28, 2012 3:18 AM
Points: 45, Visits: 394
John,
thank you for your e-mail. I ran the query as suggested by you. The only name that is displayed is the new name of the server .

Regards.
Post #973905
Posted Tuesday, August 24, 2010 4:26 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
Does this now suggest that sp_dropserver and sp_addserver are now obsolete
Thanks .


They are not obsolete. Please refer [b]this


Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #973990
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse