Posted by Erland Sommarskog on 10/01/83 11:25

Jason_Schaitel (jason_schaitel@hotmail.com) writes:
> I have tried to look in BOL and Google Groups for the how to enable the
> cross database ownership chaining option at the database level and not
> having much luck. Can you point me to it?

exec sp_dboption yourdb, 'db chaining', true

This option is not in the original Books Online, as it was added in SP3.
But it is in the updated Books Online, see link below.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: MS SQL Server 7.0 SP4 on Windows 2003 Server.
• Prev in forum: All records within x minutes of each other
• Thread view: Re: Application Roles for Cross-Database Joins

[Reply to this message]