Changing server name | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Changing server name

We’re going to replace our current SQL server with a new one. The new one will have different name than the old one. We have a number of views linked to the old server. Is there an easy way to update those views with the new server name?
Thanks!
quote:Umachandar Jayachandran
In SQL Server 2005, you can use synonyms for the objects. So you will define those when you create the linked server. In SQL Server 2000, you can create a linked server with a pre-defined name and then change the network name of the server to the actual SQL Server instance. This will allow you to reference the remote SQL Server using a specific name always in the code. You can use this approach in SQL Server 2005 also to avoid the additional steps involved in creating the synonyms. Take a look at the link below for the alias solution: http://www.sqlmag.com/Article/ArticleID/40789/To_Manipulate_Tables.html

Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Thanks, Satya.
]]>