Thingworx - MSSQL - COLLATE Change

[pshashipreetham]

Hi Team,

What SQL Commands can be used to Change the Collation/COLLATE of the MS SQL SB?

Thanks,

[pshashipreetham · Accepted solution]

Ahh found this work around quick, below are the commands need to be used as soon as the MS SQL DB is setup:

ALTER DATABASE thingworxv1 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE thingworxv1 COLLATE Latin1_General_100_CS_AS_SC;
ALTER DATABASE thingworxv1 SET MULTI_USER;

  Change the "thingworxv1" with your database.

After the executing these commands, the then COLLATE should be good for the schema setup and Thingworx Installation

Thanks,