Re: Ownership Chains and Linked Servers

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 06:31:57 -0500

Ownership chaining does not apply to queries across linked servers because
these are essentially different database connections. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Stevo" <Stevo@discussions.microsoft.com> wrote in message 
news:02DAAFDA-584E-4148-8B26-A752D6D08A7F@microsoft.com...
>I have 2 servers which are linked. All objects on server1 are owned by sa 
>and
> all objects on server2 are owned by sa. I have created a mapping between 
> sa
> on server1 and sa on server2. However the ownership chain seems to be 
> broken
> when I try and run a stored procedure from server1 which accesses objects 
> on
> server2 as a user other than sa.
>
> Any ideas?