I'm in need of some advise on cross-database joins, i.e. is it possible? What are the performamce implications? Is there a better way to achieve the following?:
I'm developing an online forum as an additional service for an established group of users, but for political reasons I'm not able to modify the database that contains the users login credentials. Therefore, I currently have two databases (one containing user accounts, the other containing forum threads/messages/etc.) on the same physical MS SQL 2K server.
When displaying the forum messages, I need to also display information that resides in the other database (name, address, etc. of the poster). How do I go about this? Is it possible to do a cross-database join in this manner?
Any suggestions would be most appreciated.