SQL Server 2008 Collation

I am installing SQL Server 2008 and for the collation i want to choose Latin1_General_CI_AS but on the drop down I don't have that option (see attached document).  How can i determine which selection will give me Latin1_General_CI_AS.
gloyola1Asked:
Who is Participating?
 
cyberkiwiConnect With a Mentor Commented:
When you are up to step Server Configuration at the left, to to the 2nd tab Collation on the right

Click Customize against Database Engine

Click the top option "Windows.."

In the list, drop down to "Latin1_General"

CI = leave Case-sensitive unticked
AS = tick Ascent-sensitive

Click OK
0
 
cyberkiwiCommented:
See attached document?
0
 
gloyola1Author Commented:
0
 
gloyola1Author Commented:
Thanks, that is what I needed.  Wow, I have been struggling for a while on this.  It sure was not very intuitive.
0
All Courses

From novice to tech pro — start learning today.