Note to self when having OCS 2007 R2/Lync Databases issues
Posted by Chad McGreanor on November 7, 2010
SQL server cross database chaining option is disabled for either rtc or rtcdyn database. This may be caused by attaching or restoring an existing database. Since this condition causes performance issues, database will not be acquired until the issue is resolved.
Please enable cross database chaining option (using “sp_dboption ‘<dbname>’, ‘db chaining’, TRUE”) for both rtc and rtcdyn databases
Run this on the rtc and rtcdyn databases
rtcdyn, ‘db chaining’, TRUE