Solved

MS SQL-Server and case-sensitive meta data...

Posted on 2011-09-02
4
305 Views
Last Modified: 2012-05-12
During the installation, one can choose settings to force case sensitive meta data in MS SQL-Server.

Q1: Is this statement through? If so, what version of SQL-Server this feature is started?

Q2: At what stage this setting takes place? Can the setting change after installation?

 hope you don't mind double questions in each line.

Thank you.

 
0
Comment
Question by:Mike Eghtebas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 36474649
the answer is: the character set installed (for master db) is what determines the case sensitivity.
so, indeed, during installation, you specify this by selecting the character set you want to install.

you cannot change that later (for master db) ...
0
 
LVL 42

Assisted Solution

by:dqmq
dqmq earned 250 total points
ID: 36474670
For SQL Server:

Q1: True--yes.  Not sure when it started, but definitely available in 2005;
Q2: As you noted, it's an installation option that affects the collation for system tables. You can use alter table to change the collations, but it's tricky business and I advise against attempting it unless you have a serious internals expert on board.  You are better off to create a new installation and import your databases to it.

PS. You may have inadvertantly posted in the wrong zone.
0
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 36474754
Thank you for noticing wrong TA and moving it to MS SQL Server.

I appreciate the comments.

Mike
0

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

751 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