Changing SQL Server Collation After Installation
We can now redefine the desired collation for database Products with the following code:
-- make sure no one else is using database
ALTER DATABASE Products SET SINGLE_USER WITH ROLLBACK IMMEDIATE
-- change collation to Modern_Spanish_CI_AI_WS
ALTER DATABASE Products COLLATE Modern_Spanish_CI_AI_WS;
-- allow users back into the database
ALTER DATABASE Products SET MULTI_USER