Are these 2 databases on the same server?

If yes, you can simply use DBName.Owner.TableName syntax.

If not:
-You can link your servers.
-You can use the OpenRowset TSQL command to retreive data from another source.


>Hi,
>
>I am developing an application in VB .Net using SQL Server for the database. I have multiple databases in SQL server and have a requirement to create a recordset in VB that takes data from 2 tables in different databases.
>
>Is there a way to create a view that combines tables from 2 databases? Or do I need to create a recordset in memory and then populate it from both tables seperately?
>
>Pete