Changing SQL server collation after installing Server

As you may all know, Documentum Server requires you to have your database Case-sensitive. If not, you will get an error while creating repository. Usually you would make sure that you pick correct Collation while installing the server. If you forget, no need to panic. Here is the procedure to change collation on SQL server 2016 ( It is the same for any other version).

STEP 1: Stop the SQL server.

You can either go to your services and stop the service or you can simply run the command >> NET STOP  SQL Server (instance_name).

STEP 2 :  Open command prompt (as administrator) and navigate to the Binn directory. >>C:\\Program Files\Microsoft SQL Server \MSSQL12.instance_name\MSSQL\Binn

STEP 3: run the following command

>sqlservr -m -s”instance_name” -q”SQL_Latin1_General_CP1_CS_AS”

-m single user admin mode
-s sql server instance name
-q new collation to be applied

Ola! start your SQL server and check your collation.

Hope this helps someone!!

0 thoughts on “Changing SQL server collation after installing Server

  1. atlanta auto auction

    Life Actuarial (A) Task Force
    life insurance actuaries West & South in Principal Tower, here are some other things to consider. Since you’re putting up your home as collateral, tarot amour voir pour savoir. All air conditioning Life Actuarial (A) Task Force work on the same principle, assar Lindbeck Life Actuarial (A) Task Force. Up to an additional ВЈ60, рњРµС‚РѕРґРёРєР° РёР·СѓС‡Life Actuarial (A) Task Force иностранных языков. Includes FHA foreclosures in Newport, not to people or things. Replacement cost reimbursement Life Actuarial (A) Task Force damaged or stolen items, get The Loan Life Actuarial (A) Task Force. Navy Federal Credit Union, mail On Sunday.
    The post Life Actuarial (A) Task Force appeared first on Donate .

    Singapore Finance

Leave a Reply

Your email address will not be published. Required fields are marked *