Before proceeding further to change the database collation, please make sure that no user is connected to the database.
Step 1: Please set your database to the single-user mode > change the collation > set back to multi-user mode in order to perform these operation you have to run the T-SQL scripts which is mentioned below:
SELECT name, collation_name FROM sys.databases; |
GO |
ALTER DATABASE [DatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; |
GO |
ALTER DATABASE [DatabaseName] COLLATE CollationName; |
GO |
ALTER DATABASE [DatabaseName] SET MULTI_USER; |
GO |
SELECT name, collation_name FROM sys.databases; |
GO |
Enter your actual database name and collation name in the above example.
In order to check the available collations you can run the command mentioned below:
| SELECT * FROM fn_helpcollations() |
