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

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

29 July 2022

  • curprev 10:3510:35, 29 July 2022LaySwan talk contribs 1,121 bytes +1,121 Created page with "'''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] File:Alter table advqt1.png File:Alter table advqt2.png <u><b>Possible Reason:</b></u> The registry value failed to upgrade properly when upgrading the database...."