Database Collation Changing Problem

Finance and Operations/AX Technical Forum
1

Hi All,

I have a Ax database with the collation: Latin_General_CS_AS

Then I was trying to change the collate property of Ax Database in both 2tier and 3tier environment. After stopping AOS and closing all client applications, I run the SQL Query Analyzer with this script:

Alter Database AXDB Collate Vietnamese_CS_AI_KS

But it always return an Error with Desc:“Can not lock table exclusive…”

I have tried this SQL script in other database, it worked fine.

Anybody can help???

Thank you very much.

2

Hi Khue,

Not really an AX man, but have you tried setting the database to single user only first?

Just a stab, but trying to help anyway.

Tony

3

Hi, thanks for your response.

Now I change the code to set my db as single user:

alter database [axdb] set single_user with rollback immediate
go
alter database [axdb] collate Latin1_General_CI_AI_KS
go
alter database [axdb] set multi_user
go

But Ax return another error like:

Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.
Server: Msg 5075, Level 16, State 1, Line 1
The object ‘CK__PURCHPARA__RECID__0036ACAF’ is dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 1
The object ‘CK__CACDISALL__RECID__0039DA0B’ is dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 1
The object ‘CK__HRMVIRTUA__RECID__0043FBAC’ is dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 1

Anybody can help with this???

4

well,

seems like it has problem with some check constrains… not sure that I have to remove these things???[:(][:(]