title: Problem with database collation change (SQL Server 2008)
body: <p>When I tried to change the collation of my existing database (including data) from <code>ARABIC_CS_AS</code> to <code>PERSIAN_100_CS_AS</code> the following error occurs:</p>
  <blockquote>
  <p>Alter failed for Database 'XXXX'.  (Microsoft.SqlServer.Smo)</p>
  <p>An exception occurred while executing a Transact-SQL statement or batch.
  (Microsoft.SqlServer.ConnectionInfo)</p>
  <p>The object 'ItemTables' 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.<br />
  The object 'CK_FilteredReportColumnFilters' 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.<br />
  The object 'CK_FilteredReportColumnFilters_1' 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.<br />
  The object 'CK_FilteredReportColumnFilters_2' 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.<br />
  The object 'CK_Reports' 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.</p>
  <p>ALTER DATABASE failed. The default collation of database 'XXXX' cannot be set to Persian_100_CS_AS. (Microsoft SQL Server, Error: 5075)</p>
  </blockquote>
  <p>Trying to correct the errors mentioned by removing those database objects causes another error with other titles in conversion process.</p>
  <p>Any idea ?  Is there any well-defined solution to solve this problem?</p>