cross database join
March 7, 2004 05:06 PM

Make sure to install service pack 3 on SQL Server 2000 -- and check "enable cross ownership chaining".
otherwise you'll have to grant permissions on individual tables (beyond what you might expect to get that to work), as a workaround