Bob ---
You mean like a JOIN or something relying on the two different tables? I don't see why not. And you can have multiple connections in a single database (DBC) so why worry about multiple databases?
>Quick Question...
>
>Can I access 2 Different Databases on 2 different connections
>and do a query between them??? Is this even do-able?
>
>(We have a very strange request to query information real-time
>between our Web Server on SQL Server Database A, and our
>Contact Management system on SQL Server Database B...)
>
>Thanx!
>Bob :-)
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05