当我试图将现有数据库(包括数据)的排序规则从ARABIC_CS_AS
更改为PERSIAN_100_CS_AS
时,出现了以下错误:
数据库"XXXX"的Alter失败.(Microsoft.SqlServer.Smo)
执行Transact-SQL语句或批处理时出现异常. (Microsoft.SqlServer.ConnectionInfo)
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.
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.
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.
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.
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.ALTER DATABASE失败.数据库‘XXXX’的默认排序规则不能设置为PERSIAN_100_CS_AS.(Microsoft SQL Server,错误:5075)
试图通过删除这些数据库对象来纠正提到的错误会导致转换过程中其他标题出现另一个错误.
有什么 idea 吗?有没有明确的解决方案来解决这个问题?