Rename SQL server Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Rename SQL server Server

Rename SQL server Server

Rate Topic

Display Mode

Topic Options

Author

Message

lianvh

Posted Tuesday, August 24, 2010 1:47 AM

SSC 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

John Mitchell-245523

Posted Tuesday, August 24, 2010 1:54 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:18 AM
Points: 4,418, Visits: 7,168

If you run SELECT [name] FROM sys.servers, do you see the old server name, or the new one?

John

Post #973897

lianvh

Posted Tuesday, August 24, 2010 2:19 AM

SSC 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

Adiga

Posted Tuesday, August 24, 2010 4:26 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:50 AM
Points: 1,618, Visits: 20,898

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 »

Permissions