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.
Solution:
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.
--Source from AutoCount Wiki --