Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've just joined the data team of a new company and we have a large SQL Server environment (100+ instances) and cross database ownership chaining is on by what I gather is a necessity. I'm looking for 3rd party tools or even scripts for some way to audit potential access to a database including the potential of cross-database ownership chaining. Does anyone know of any way to accomplish this, or any products that do the same sort of thing?

I have mostly 2008 R2 and some 2012 instances; there may be one or two 2005 machines but they can be safely ignored. Most are Enterprise Edition although some might be Standard Edition.

share|improve this question
Are you just looking to find out which databases and/or instances have this set? – Thomas Stringer Dec 7 '12 at 14:56
No, I don't think so; I apologize if I'm a little hazy on the overall concepts, but the idea is to ascertain, bearing in mind what instances/dbs have this enabled, who could have potential access to an object/database both directly, and as a potential access through, say, creating a stored procedure on another database using cross database ownership chaining. – Nic Neufeld Dec 7 '12 at 18:36
What version(s) of SQL Server are you using? – SQLRockstar Dec 7 '12 at 19:39
@SQLRockstar, [op reports] I have mostly 2008R2 and some 2012 instances...there may be 1 or 2 2005 machines but they can be safely ignored. EDIT: Enterprise Edition mostly as well. May be some Standard. – jcolebrand Dec 7 '12 at 20:35
I don't know of any scripts to accomplish this, but SQL Secure from Idera mentions the ability to evaluate cross database chaining. – sqlbattsman Dec 8 '12 at 14:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.