magritton
7/5/2015 - 12:00 PM

SQL Database chaining

SQL Database chaining

SELECT [name], value  
FROM [sys].configurations 
WHERE [name] = 'cross db ownership chaining';

SELECT [name] AS [Database], [is_db_chaining_on] 
FROM [sys].databases 
ORDER BY [name];