I apologize if someone has already asked this before but I couldn't
find it.

Here is the situation:

I have two datbases A and B. My main database is A but evey once in a
while I need to get data out of B. So rather than making a roundtrip
to query minimal amount of data from B what I would like to do is call
the stored procedure that gets the data from B from the A database.

So A.GetData will call B.GetData and then return the results with the
call for A.GetData.

Is this possible?

I can't seem to see how I can call into the other database from my
current database.