Posted by Ed Murphy on 06/15/07 22:12

Erland Sommarskog wrote:

> Ed Murphy (emurphy42@socal.rr.com) writes:
>> The problem is that the name of the source database varies from
>> one system to another, so I want to pass the database name as a
>> parameter. I think I could do the following, but is there a
>> better way to go about it?
>
> On SQL 2005 you could use synonyms:
>
> CREATE SYNONYM mytable AS thatdatabase.dbo.hertable
>
> When you move to a new database you only need to update the synonyms.

Alas, this is SQL 2000 (or at least I expect it will be in a
significant number of cases).

[Back to original message]