I was struggling with how to tackle this type of problem in T-SQL until I came across your sample code Jeff.

What can I say?

A bloody marvelous and timeless piece of...

I have two databases in one instance of SQL Server. In DB1 I have Table_1 and in DB2 I have a synonym that points to Table_1 in DB1. ...

I'm with DiverKas on the theological argument that goes with this article.

If you were a 'Solutions Provider' and implemented this unsupported technique on a fee paying client site...

Lots of really useful points from my predecessors here. I'd just like to add a link to an extremely helpul document on this topic written by Andy Baron of...