You're all stars (particularly NPeeters in this case as he put the finger on the problem). I checked the SIDs of the dbo user in each database, and on the...

Yes, Steve, I also believed the ownership chain would cross databases, all my objects are owned by dbo! It doesn't work though. I am on SP2. Reading the documentation for...

No, if the app is using stored procedures, then you do NOT need explicit rights to the tables it references - that is the whole point of the security model....

Yes I'm now looking into this product as well as I need SourceSafe integration. It looks as though it uses the same compare engine. The SQLDiff product is strictly compare...

I have tried this product, and it's an SQLCompare killer.....

I have looked for a long time for a product to accurately compare a large database a client of mine has...

Andy did add the caveat that MS Access is not the answer to all problems, but personally I am sick and tired of resolving locking problems on SQL Server caused...