Changing SQL Server collation to case insensitive from case sensitive?

by

You basically need to run the installation again to rebuild the master database with the new collation. You cannot change the entire server’s collation any other way.

See:

Update: if you want to change the collation of a database, you can get the current collation using this snippet of T-SQL:

SELECT name, collation_name 
FROM sys.databases
WHERE name="test2"   -- put your database name here

This will yield a value something like:

Latin1_General_CI_AS

The _CI means “case insensitive” – if you want case-sensitive, use _CS in its place:

Latin1_General_CS_AS

So your T-SQL command would be:

ALTER DATABASE test2 -- put your database name here
   COLLATE Latin1_General_CS_AS   -- replace with whatever collation you need

You can get a list of all available collations on the server using:

SELECT * FROM ::fn_helpcollations()

You can see the server’s current collation using:

SELECT SERVERPROPERTY ('Collation')

More Related Contents:

  1. How to split a comma-separated value to columns
  2. Using T-SQL, return nth delimited element from a string
  3. How to get a float result by dividing two integer values using T-SQL?
  4. Get first day of week in SQL Server
  5. SQL Server add auto increment primary key to existing table
  6. How to delete large data of table in SQL without log?
  7. Confused about UPDLOCK, HOLDLOCK
  8. Retrieve column definition for stored procedure result set
  9. Change Notification with Sql Server 2008
  10. Do while loop in SQL Server 2008
  11. Query times out when executed from web, but super-fast when executed from SSMS
  12. TSQL: How to convert local time to UTC? (SQL Server 2008)
  13. Regular Expressions in SQL Server servers?
  14. Unique constraint on multiple columns
  15. Transpose rows and columns with no aggregate
  16. How to find the port for MS SQL Server 2008?
  17. How to set monday as first day of week in SQL Server
  18. Drop primary key using script in SQL Server database [duplicate]
  19. How to convert number of minutes to hh:mm format in TSQL?
  20. SQL Server Configuration Manager cannot be found
  21. Temporarily disable all foreign key constraints
  22. How to display two digits after decimal point in SQL Server
  23. The request failed or the service did not respond in a timely fashion?
  24. Merge multiple rows into a single row
  25. How to wait for 2 seconds?
  26. Cannot Resolve Collation Conflict
  27. What are row, page and table locks? And when they are acquired?
  28. Find broken objects in SQL Server
  29. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?
  30. Populate Dataset With Table Names From Stored Procedure

Leave a Comment