How to change the collation of an SQL Server Database

ALTER database DBNAME set Single_User with Rollback Immediate
GO
ALTER DATABASE DBNAME COLLATE NEW_COLLATE --Latin1_General_CI_AS
GO
ALTER DATABASE DBNAME set multi_user
GO