Use when horizontal DB pivoting is possible.
Check
SELECT name,value_in_use FROM sys.configurations WHERE name='cross db ownership chaining';
Lateral DB Pivot
USE dbA;SELECT * FROM dbB.sys.tables;
Use when horizontal DB pivoting is possible.
SELECT name,value_in_use FROM sys.configurations WHERE name='cross db ownership chaining';
USE dbA;SELECT * FROM dbB.sys.tables;