SELECTING COLLATION WHEN INSTALLING MSDE.

[Bigfootguy]

When you install MSDE, the installation is unattended (or silent), rather than interactive. I need to specify collation, but it does not allow me to do it, installing instead the default which is no good for me. How can I select (or change) a collation in MSDE? Thanks. Best Bigfootguy

[darXstar]

set COLLATION parameter when you run msde Setup : setup COLLATION="Latin1_General_CI_AI" DATADIR="C:\" TARGETDIR="C:\Programmi\Microsoft SQL Server\" /L*v C:\msdelog.txt SAPWD="[your passw]" Latin1_General_CI_AI means Case_Insensitive Accent_Insensitive you can specify also CI_AI_KI for Katana an so on.. option not specified means default value. darx