Re: Query Two Databases

[Duncan Hill]

On Thursday 25 January 2007 11:08, Neil Tompkins wrote:
> The databases are on the same server, however the login details for each
> database are different.
>

A query executes with the credentials of the authentication used to set up the 
connection.  If you want to query two tables simultaneously across two 
databases, the user used to run the query will need SELECT access to both 
database.tables.
-- 
Scanned by iCritical.