Cross database ownership chaining

One of the Gotcha when you migrate a database from SQL 2000 to SQL 2005 "Cross database ownership chaining" is turned off by default.

You would need to enable it manually once you have restored the database.

This option is available under "Server Properties" in "Security" tab.

You can either Execute the SQL below or you can change the server property using Management Studio.
EXEC SP_DBOPTION "(DB Name)","DB CHAINING", "TRUE"

If you wish to check is the database chaining is ON / OFF you can using the following statement
EXEC SP_DBOPTION "(DB Name)","DB CHAINING"

Thanks
Sutha