>Ok, thanks.
>But it only changes the database all the columns have the original collate
>
>I need also change the columns
and
The COLLATE clause can be applied only for the char, varchar, text, nchar, nvarchar, and ntext data types.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst