Accounting 2.0 - Prompted Message: Error during upgrade to 2-Invalid Data Definition Language Statement and ALTER TABLE dbo.ADVQT…Guid

From AutoCount Resource Center

Question: When upgrade database from 1.9 to version 2.0, error message prompted “Invalid Data Definition Language Statement, error message is Column already has a DEFAULT bound to it”. After click OK, another message prompted “ALTER TABLE [dbo].[ADVQT] ADD DEFAULT (newid()) FOR [Guid]

Possible Reason:

The registry value failed to upgrade properly when upgrading the database.


1) Search and open SQL Management Studio from window search.

2) Click the database name and Execute the below query:

UPDATE REGISTRY SET RegValue = '2.2.23' WHERE RegID = 2

Now, you may login to AutoCount Accounting 2.0 again and proceed with the database upgrade.

Note: Please seek assistance from your software dealer if the problem persists after performing the suggested steps.

By: Jodie 220715, Lay Swan 220727, P220728

Go to menu

AutoCount Accounting 2.0 & 2.1

AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS

AutoCount On The Go
AutoCount Accounting Plug-In Documentations