Some notes on software development... RSS 2.0
# Tuesday, 08 September 2009

If you change the name of a computer running SQL server you must also update the system metadata stored in sys.servers.
First check the current name by using

If @@SERVERNAME does not show the correct computer name you should change it using the following commands:

select @@SERVERNAME

sp_dropserver <old_name\instancename>
GO

sp_addserver <new_name\instancename>, local
GO



Last step is to restart the SQL Server instance.

Links
How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server

Tuesday, 08 September 2009 08:26:13 (GMT Standard Time, UTC+00:00)  #    -
SQL Server
Navigation

Sign In
Extras
Statistics
Total Posts: 116
This Year: 0
This Month: 0
This Week: 0
Comments: 36
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2017
Hadrian Phillips

All Content © 2017, Hadrian Phillips
DasBlog theme 'Business' created by Christoph De Baene (delarou)