>I have all databases using "SQL_Latin1_General_CP1_CI_AS" exept one.
>
>This database uses "Modern_Spanish_CI_AS"
>
>How can I chage this collate from "Modern_Spanish_CI_AS" to "SQL_Latin1_General_CP1_CI_AS"?
ALTER DATABASE yourdatabase COLLATE SQL_Latin1_General_CP1_CI_AS
Execute the system function fn_helpcollations to retrieve a list of all the valid collation names for Windows collations and SQL collations:
SELECT *
FROM ::fn_helpcollations()
_______________________________________________________________
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