Just a thought -

Inside this procedure:

[DK_SQL_01].SimpleDayFeeder.dbo.SimpleDaysUpdateOnHand

Does your login have privileges to all the tables views, etc. contained within?



>I have linked a Sql2005 server in a multi server environment in order to run remote queries.
>
>I did setup security, so that
>
>Select Top 10 * From [DK_SQL_01].Fleet.dbo.Inventory
>
>works and returns results
>
>But:
>
>EXEC [DK_SQL_01].SimpleDayFeeder.dbo.SimpleDaysUpdateOnHand
>
>Returns:
>Server: Msg 7416, Level 16, State 1, Line 1
>Access to the remote server is denied because no login-mapping exists.
>
>I believe I have set up correct login mappings, since the query works, but I keep getting this error.
>
>TIA
>
>Peter