Adding linked server - SQL Server 2005 - Changing the name later

I'm developing a web app in a testing environment with test sql servers and databases. I'm curre开发者_JS百科ntly adding a linked server and accessing the databases and tables in the linked server using [Servername].[DatabaseName].dbo.[TableName].

But after pushing it to production the DB servers name will change. So should i need to open each and every stored procedure again and change the server name?

What is the usual practice?

Thank you.

The link name need not be the same as the actual target server name. The easy solution is to use the same linked server name on both the development and production servers, just link to different actual servers. A development server might actually link to itself, for example.