A time may come when you will need to alter your database to use a different collation. You can do this by using the following snippet:
ALTER DATABASE [DatabaseName]
COLLATE SQL_Latin1_General_CP1_CI_AS ;
--Verify the collation setting.
SELECT name, collation_name
WHERE name = N'[DatabaseName]';
When you execute the above snippet you may come across the following error: This error occurs when your database is in Multi-User mode or when there are objects referring to your database. To overcome this error, you…