I'm working on a system where the stored procs are all saved to a "central" database library. The tables from which the procs read are in different (many) databases. When I attempt to look at the estimated execution plan for any sp, the result just shows the "use database" statement and the actual execute line from the proc. Is this due to the designer's decision to put all stored procs in a central database that does not contain the tables from which the actual proc reads? That's my suspicion. If that's the case, then doesn't it follow that this is not a recommended practice for performance? I've already had the discussion about why it's not the most intuitive course of action, but I'm the "consultant." Thanks!