Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-07-21 : 17:22:18
|
| Hi,Today, I installed sql server 2008 express.I see that on running sql queries, the system is case sensitive.How can I solve this please?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-07-21 : 17:43:00
|
| Is it the server collation or database collation? If it's the server collation then you'll probably have to reinstall. If it's just a database collation you want to change, you can do that with ALTER DATABASE. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-07-22 : 03:57:40
|
| Not sure whether itis the database or the server because I just did the standard sql server 2008 express install.How do I check this?Thank you |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-07-22 : 07:36:52
|
| SELECT name, collation_name FROM sys.databasesIf master case a case-sensitive collation (_CS instead of _CI) then you'll have to reinstall. |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-07-22 : 08:06:12
|
| It shows as:master SQL_Latin1_General_CP1_CI_ASSo I guess I do not have to re-install?How do I fix this case sensitivity?Thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-22 : 09:20:05
|
| http://msdn.microsoft.com/en-us/library/ms174269.aspx |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-07-22 : 18:14:27
|
| Thanks |
|
|
|
|
|
|
SQL Server 2008 express case sensitive