Tagged: SQL
  • admin
  • Dec. 8, 2016, 8:14 p.m.
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."
  • admin
  • May 27, 2016, 9:13 p.m.
In this blog post we will have a look, how to use SQLConnection objects in case of multi-threading.
  • admin
  • May 2, 2016, 9:32 p.m.
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.
  • admin
  • April 18, 2016, 9:50 p.m.
This blog post will show you some ways to execute stored procedures from POS using standard API: SqlStoredProcedure and DBUtil from DataAccess DLL.