Stored Procedures: lookup a table in another DB

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

SQLZ SSChampion Points: 12872 More actions · Answer 1

Hi Dinu,

Yes. Just reference the table by fully qualifying it with the database and owner name.

e.g. select * from somedatabase.dbo.mytable

Dinu E Anastasiu Ten Centuries Points: 1177 More actions · Answer 2

Ten Centuries

Points: 1177

June 1, 2006 at 12:55 pm

Many thanks Karl!

Dinu