Offline Sync service fails to synchronize data with error "Bulk command BulkInsertCommand failed with the following exception. Rows will be retried during single apply. System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated."
In this blog post we will have a look, how to use SQLConnection objects in case of multi-threading.
Sometimes when Offline Sync Service is syncing a large table (with much data), it’s interesting to check the status of sync - to validate how many records have been already inserted. For this we can execute Uncommitted read in SQL Management Studio.
This blog post will show you some ways to execute stored procedures from POS using standard API: SqlStoredProcedure and DBUtil from DataAccess DLL.