Skip to content

250808-2 - bugfix Importer only

Pre-release
Pre-release

Choose a tag to compare

@larspl larspl released this 07 Aug 18:45
· 13 commits to development since this release

Added the WITH keyword to create valid SQL syntax:

Change Made
In SqlWatchInstance.cs around line 613:

Before: string lockHint = tableName.Contains("sqlwatch_logger") ? "(ROWLOCK, READPAST)" : "(ROWLOCK)";
After: [string lockHint = tableName.Contains("sqlwatch_logger") ? "with (ROWLOCK, READPAST)" : "with (ROWLOCK)";]
Result
✅ Build completed successfully
✅ Executable updated with the fix
✅ MERGE statements will now have correct SQL syntax with proper table hints
This should resolve the "Incorrect syntax near '('" error you were seeing in the merge operations for the sqlwatch_logger_snapshot_header table and other tables using the optimized merge approach.