OK, sorry for all the posts. I am trying to find the best way to accomplish a specific task and I keep hitting some walls.
I got the linked server thing to work, and this question is somewhat related to that. Is there any way to "alias" a database? Let me explain...
Our application has two databases. The main "production" database and an archive database. We have a process in which database is "archived" from the production db to the archive db. However, we can't always guarantee that the archive db will always be called the same thing.
So, we want to be able to Alias it so that the code in the production db never needs to be changed.
Does this make sense?
Any input is greatly appreciated...
Author - Professional SQL Server 2005 XML