Skip to Content
Former Member
Mar 13, 2007 at 11:07 AM

SQL Server 2005 Express Collation issue


Hi all,

I am installing SQL Server 2005 Express for use with SBO2007Preview. I am looking for the COLLATION "SQL_Latin1_General_CP1_CI_AS". There seems to be no option available to select the "SQL_Latin1_General" from the Intallation Drop Down List. The closest is the "Latin1_General" selection. Furthermore, I selected "Latin1_General" and selected the "Accent_Sensitive" and when I viewed the DB Properties, the Maintenance>Collation = "Latin1_General_CI_AS<b>_KS_WS</b>"....hmmm....

Seems like the SQL Server 2005 Express Edtion does not offer the "<b>SQL_</b>Latin1_...." option....

Can anyone out there help? Thanks