I m developing a web app in a testing environment with test sql servers and databases. I m currently 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.
This query originally came from a VB6 program accessing MS Access tables which are linked to external databases through ODBC. It takes about 3:30 to run. Now I ve setup a SQL Server 2008 Express box ...
I m developing a web app in a testing environment with test sql servers and databases. I m currently adding a linked server and accessing the databases and tables in the linked server using [...
I have run into a strange problem using SQL Server 2000 and two linked server. For two years now our solution has run without a hitch, but suddenly yesterday a query synchronizing data from one of the ...
When running a SQL statement or a stored procedure on a database, can you connect to an external database and pull data from there? something like: SELECT a.UserID, b.DataIWantToGet FROM mydb....
I have a WebTrends ODBC source on server1 and a SQL Server 2005 on server2. I want to connect to this ODBC from SQL Server on server2. So far, I managed to connect to this ODBC from SQL Server which ...
I am using MS SQL Server 2000 and have a link from a test db to a live db which is in replication. The link seems to work fine and I can select from any of the tables using any of the fields apart ...
Trying to update a table on a linked server (SQL 2000/2005) but my server name will not be known ahead of time. I m trying this: DECLARE @Sql NVARCHAR(4000) DECLARE @ParamDef NVARCHAR(4000) DECLARE @...
We re looking to iron out issues in our different dev/test/prod environments. Currently we have to remember to change the name of linked servers in stored procedures when we migrate from UAT into ...
