How to Change Database Collation

To change the collation of your MS SQL database, follow these steps. Ensure you have a backup before proceeding.

 

-- Set the database to single-user mode
ALTER DATABASE [YourDatabaseName]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

-- Change the collation
ALTER DATABASE [YourDatabaseName]
COLLATE YourDesiredCollation;

-- Set the database back to multi-user mode
ALTER DATABASE [YourDatabaseName]
SET MULTI_USER;

-- Verify the change
SELECT name, collation_name FROM sys.databases WHERE name = 'YourDatabaseName'

 

Replace YourDatabaseName with your database name and YourDesiredCollation with the desired collation (e.g., Arabic_CI_AS).

Note: This process requires exclusive access to the database and may briefly interrupt connections.