Hi All,
 I am getting "collation conflict for union operator" while
i try to connect union queries in different database but in same server.

Vijay,

In Enterprise Manager, right mouse click on one of the databases in question and select Properties. The brings up the database properties page. ON the General tab of the properties page at the bottom, it will list the Collation name. Check this for both databases. Are they different? If they are, there is your problem. The solution is not a good one. You can't really change a database collation after it is created.

However, if they are the same, you can set collation PER COLUMN in a database. OPen the table in one of the tables in question in design mode and click on one of teh columns you are joining on. Look at the properties of that column, specifically the Collation. Do the same for the other table. Are the Collations different for the two tables? YOu should be able to change the collation for one column to match the other.

Hope this helps...

Scott