Retrieving Data From A Different Database

[rplcmint]

Right now I'm running a stored procedure on my Premium Database....I need to retrieve a single record from a different database on the Address Database (same machine).

Is there a way that I can retrieve this data in the SP to hit this 'remote' database. Is there a easy procedure to make a call and retrieve data and continue with my SP. It can be a cursor..I know how to do that.

The other option is let develop my VB code to connect to the second database and make the retrieval.

Whatcha think?

[vb_dba]

If your using SQL Server, you can query the other database like this:

Select *
From [dbname].dbo.myTable

Where dbname is the name of the database you are looking at and myTable is the name of the table you are quering w/in that database.

[rplcmint]

That was easy enough!

Thanks for the tip!