How to set the Collation properties of the database

-- set to the single user exclusive mode

ALTER DATABASE testdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE
go

-- modify the collation properties as SQL_Latin1_General_CP1_CI_AI

ALTER DATABASE testdb COLLATE SQL_Latin1_General_CP1_CI_AI

go

-- restore to multi user mode.

ALTER DATABASE testdb SET MULTI_USER
go