Solved

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

Posted on 2011-09-02
4
289 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
4 Comments
 
LVL 142

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

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
SQL Server 2012 r2 - Varible Table 3 27
SQL Error - Query 6 27
transaction in asp.net, sql server 6 37
get backup failed extended events 4 7
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

825 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