SQL Server is not currently supported here on QnA. They're actively answering question in dedicated forums here.
https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqldatabaseengine&filter=alltypes&sort=lastpostdesc
SQL Server update to version 18.5.1 from 18.5 seems to cause a write error on a query with related tables
maryd
1
Reputation point
SQL Server update to version 18.5.1 from 18.5 seems to cause a write error for a query with 2 related tables. This works in 18.5 and SQL server 2012. We have an Access front-end using a simple query between two related tables as the record source. Updating any fields from the "primary" table causes a time-out due to inability to write to the table. I also created this same query in SSMS and I get the same error so it seems not caused by the the Access front end.
1 answer
Sort by: Most helpful
-
Yuji Masaoka 56 Reputation points
2020-06-22T16:56:40.723+00:00