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?