Solved

SQL Server 2008 Collation

Posted on 2011-02-15
4
361 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:gloyola1
  • 2
  • 2
4 Comments
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 34903173
See attached document?
0
 

Author Comment

by:gloyola1
ID: 34903200
0
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 500 total points
ID: 34903226
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
 

Author Closing Comment

by:gloyola1
ID: 34903301
Thanks, that is what I needed.  Wow, I have been struggling for a while on this.  It sure was not very intuitive.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Calculating Business Hours 19 81
Row-Level Security 2 32
Upgrading an old legacy SQL server 20082 to 2014 - TSQL compatibility 3 36
sql Total query 2 14
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now