Post reply

Find if Cross-database ownership chaining is disabled

  • August 29, 2007 at 9:30 am

    #180739

    I am trying to write a sql query that would tell me if cross-database ownership chaining is disabled for sql server 2000/2005.  If anybody could help me with this that would be awesume.

    -Kyle

  • August 30, 2007 at 1:44 am

    #730345

    Hi Kyle,

    you can get this from

    SELECT value_in_use FROM sys.configurations
WHERE name='cross db ownership chaining'

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • August 30, 2007 at 6:46 am

    #730405

    Is Cross-Database Ownership chaining not relevant to SQL Server 2000?

    -Kyle

  • August 30, 2007 at 7:07 am

    #730417

    Hi Kyle,

    Cross-Database Ownership chaining is relevant to SQL Server 2000.

    I'm not sure how you could query it in your scripts on 2000 though. You can find out if it is set using:

    EXEC sp_configure 'Cross DB Ownership Chaining'

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • August 30, 2007 at 7:19 am

    #730422

    Thank you much.  This is actually an SSIS configuration database I am creating and I already had sp_configure added to the modules.  However, it took you pointing this out to find the cross-database chaining.

    -Kyle

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply