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