I have two databases in a same sever of MS SQL Server 2005. Now I want to make query from tables of each database. How can I do this ? and how will connect to both databases at time to peform query in tables of both using UNION clause.

Nasreen