george sibbald (5/14/2010)
What I take from this is if all your databases have the same owner,and a requirement for database chaining comes up, enable it at the database level, not the server level.
Agreed - although there isn't a chaining option at the database level. You would set that up by granting access to the necessary users - or, create a user with no login - the appropriate certificate and access and then use execute as for those procedures that need access in the other database. Or, other options...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs