I have a fairly simple select statement that joins three tables from two SQL Server 2000 databases. It works fine, but now I need to run the stored procedure against different servers, so my hardcoded reference to the second database (currently coded as "secondDB.tableName.columnName") needs to be changed to "@Variable.tableName.columnName" except SQL Server doesn't like that. Is there a way to reference a remote server/database using a variable?
October 9, 2008 11:20 PM
October 9, 2008 11:50 PM