how to determine if Cross DB Ownership Chaining

During the SQL Server install the Cross DB Ownership Chaining option can be
turned on at the server level. How can I determine if the server has it
turned on?
Thanks.
EXEC sp_dboption 'database_name','db chaining'
David Portas
SQL Server MVP
|||That should be the sp_configure setting. Please read about this setting in Books Online so you
understand the relationship with the database setting as well...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:2504E3E6-5757-476B-BA57-E3AC890D9FBF@.microsoft.com...
> During the SQL Server install the Cross DB Ownership Chaining option can be
> turned on at the server level. How can I determine if the server has it
> turned on?
> Thanks.
|||Sorry, you asked for the server setting. Use sp_configure as Tibor says.
David Portas
SQL Server MVP
|||Thanks Tibor and David!!!