Wed Dec 12 08:27:00 2012 - ExecuteSync (c#) for Returned = [Failed to execute the command 'InsertCommand' for table 'TableLogVariable_QUALITY_FACTOR' the transaction was rolled back. Wed Dec 12 08:27:00 2012 - ExecuteSync (c#) for Returned = [Failed to execute the command 'UpdateMetadataCommand' for table 'TableLogVariable_CONFIDENCE' the transaction was rolled back. Wed Dec 12 08:27:00 2012 - ExecuteSync (c#) for Returned = [Failed to execute the command 'InsertCommand' for table 'TableLogVariable_PULSE_HEIGHT' the transaction was rolled back.

commandText.Append(string.Format('USE SET MULTI_USER ', databaseName)) Īs I stated, I have a number of syncs running on individual tables, and they run just fine, AS soon as I issue the SqlDependancy.Start() command, a number of syncs end, with varying errors. I merely initiate the service broker to watch for SQL notifications. The service broker is a MICROSOFT application!!! (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)Īt .OnError(SqlException exception, Boolean breakConnection)Īt .OnError(SqlException exception, Boolean breakConnection)Īt .ThrowExceptionAndWarning()Īt .WriteSni()Īt .WritePacket(Byte flushMode)Īt .ExecuteFlush()Īt .TdsExecuteRPC(_SqlRPC rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)Īt .RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)Īt .RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)Īt .RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)Īt .ExecuteReader(CommandBehavior behavior, String method)Īt .ExecuteDbDataReader(CommandBehavior behavior)Īt .()Īt .ExecuteSelectRowCommand(SyncRowMetadata rowMetadata, DataTable& dataTable)-Sync-0 Inner: (0x80131904):Ī transport-level error has occurred when sending the request to the server. Ensure that the command syntax is correct. : Error in Sync (SyncException) Failed to execute the command 'SelectRowCommand' for table 'TableMudflowPulses' the transaction was rolled back.

It appears that when I have an active Sync in progress and I setup a SQL Notification on the same table, I start getting errors such as this: In this scenario, it should see changes as a result of the sync are happening to the server. My other application is using SQL Notifications to tell it when any changes are made to the SQL Server database and will act on I have an application that is running Sync Framework to keep a local SQL CE database in sync with a remote SQL Server database.

Show sync provider notifications