I need change collation from default to Chinese. A blank database is created in Headquarters Administrator and then Change Collation command is executed. But a Error ?object CK_APIExportLog_ObjectType depend on collation? happened. How can I do it?
Change Collation failed in RMS Headquarters
May 31, 2005
6 Replies
hi, Antonio Thanks for your reply. Now I removed CK_APIExportLog_ObjectType and changed collation. But there have a error yet as follow(this error message is Chinese and I translate it to English)
[SQL-DMO]this index is generated by DRI"PRIMARY" or "UNIQUE KEY" CONSTRAINT. It can't be modified or removed.Now Database Collation is changed to Chinese but I think some objects are changed failed.
Do you have any idea about it? And I > Jerry wrote:
Remove from your database the constraint CK_APIExportLog_ObjectType, and when you changed collation add it the constraint.
bye antonio
I think that in addition to first contraint it is necessary to add the constraint and to verify all index and database integrity.
antonio
Yes, the problem can to be a custom table, custom field or other..
antonio
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required