Retrieving Data From A Different Database

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?:rolleyes:

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

Code:

---

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.

That was easy enough!

Thanks for the tip!