>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 :-)
I think you could do it. Create two remote views, then you can create a view using those two views, or you could query the views...
select * from v_database1file,v_database2file into cursor combined
BOb
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only