get records from 2 databases

[Westond]

I have 2 databases "A" and "b" they are both on the same server. They are seperate applications except I would like for database b to be able to access the user record in database a. Database b has some userid values that match the database a users table which has all the names and user info. Can I setup a view in database b that will get the information or do I need to make a trigger in database a that moves all changes to b? And how do I go about setting up such a trigger?

THANKS!

 

[bborissov]

You can get the records of base A table from base B:

Try this in QA

USE B
GO
SELECT * FROM A.dbo.TableFromBaseA TblA

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.