To change the collation of Sql Server 2008 Database, you’ll first need to drop the objects in the database that are dependent of the collation (like functions for instance). Otherwise you will get an error like this
The object ‘…’ is dependent on database collation.
Once you’ve dropped these objects, you can set the collation using this t-sql
1 2 3 4 5 6
ALTER DATABASE [dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE [dbname] COLLATE SQL_Latin1_General_CP1_CI_AS ALTER DATABASE [dbname] SET MULTI_USER
After this, you’ll have to recreate your dropped objects.