Msg 5075 - The database collation cannot be changed if a schema-bound object depends on it

Question: I executed a ALTER DATABASE COLLATE statement and received the following error message. How can I fix and proceed with ALTER DATABASE COLLATE procedure?

ALTER DATABASE My database

COLLATE  Latin1_General_100_CI_AS_KS ;

Msg 5075, Level 16, State 1, Line 1

The object 'CK_MyCheckConstraint_Uid' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.

Answer: The reason for this message is you haven’t met  one or more of these conditions:

1)      Must have an exclusive lock on the database - read more on SQL Server ALTER DATABASE , change collation and exclusive lock

2)      No schema-bound object can be dependent on the database collation. Schema-bound objects include: User defined functions (UDF) and views created with SCHEMABINDING

3)      CHECK CONSTRAINTS

4)      Computed Columns

5)      Table-valued functions   with character columns using collations inherited from the default database collation

In the case above , it appears there is a CHECK CONSTRAINT dependant on the database collation.

Proceed with scripting out the dependant objects, drop the objects  change the database collation and recreate the the oblects from the scripts.

Make sure you have a BACKUP in place before you proceed with these steps!!