STORED PROCEDURE TO QUERY ANOTHER DATABASE

[niall29]

Hi All,

This one I thought would be easy but I can't get it to work. I am tring to call a stored procedure on DB A which then has to look up values on DB B.
Is it possible for a stored procedure to query a different database without giving direct select access to any database. It seems if you give Execute permissions to a stored procedure it is only good on that database.

Any suggestions would be greatly appreciated.
Thanks in advance

 

[r937]

perhaps you might wish to re-post this question in forum183

this is the ANSI SQL forum

r937.com | rudy.ca