view union problem

[jasie24]

what is the problem when i try to make a union between two views.

gives me this message:
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for UNION operation.

Lots of thanks to any help.

[Krzemo]

It is rather a problem with database or data stored in it ...

It seams that U set the SQL Server database collation property to a collation setting that is different from the server default collation or U have 2 tables/columns with different collaction specified or different collaction is defined on views....

Check collation of database\table\column and check also source of view.
Sometimes it helps if U specify collation in select eg:
COLLATE SQL_Latin1_General_CP1250_CI_AS

Best regards,
Krzemo