OfficeDocs-Support icon indicating copy to clipboard operation
OfficeDocs-Support copied to clipboard

Compatibility Level 150 - is this still an issue

Open hardkorehak opened this issue 4 years ago • 3 comments

We just upgraded our SQL server to 2019 (Compatibility Level 150) and are suddenly experiencing this issue. We have added Timestamp columns, we don't have Datetime2 columns, and I am still getting the Write Conflict warning. We are dropping to 120, but I don't feel that should be our end solution.


Document Details

Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

hardkorehak avatar Oct 20 '20 18:10 hardkorehak

Hello @hardkorehak,

Thanks for reporting this Issue.

Could you please shed some lights when do you get this error?. When you try to Insert,Update or while Importing the Data to the Table ?

nk-gears avatar Jun 23 '21 07:06 nk-gears

We have our primary database at CL110 right now. These were happening on linked tables in MSAccess, our primary UI at the time, on Insert/Update. We have decided to move on, since it's been 8 months since my initial issue was sent in. We are in the process of upgrading our entire interface from Access to Blazor pages, and eventually moving the SQL Server from fully on-prem to Azure.

hardkorehak avatar Jun 23 '21 13:06 hardkorehak

ok @hardkorehak , Thanks for the details. Will forward this to the technical team to look into further.

nk-gears avatar Jul 10 '21 09:07 nk-gears