ServiceBrokerListener
ServiceBrokerListener copied to clipboard
dyatchenko
Component which receives SQL Server table changes into your .net code.
I'm using SqlDependecyEx in my code to monitor a table change (ms sql server) and noticed that the message queue which stores all those changes is just getting bigger and...
When we do a bulk update of all table rows (107 838 records), an error occurs: ``` Notification Loop Exception: System.OutOfMemoryException: Array dimensions exceeded supported range. at System.Data.SqlClient.TdsParser.TryReadPlpUnicodeChars(Char[]& buff, Int32...
Add Table Name With Schema For the times using single event's for multiple tables
Sometimes a lot of records are changed at once in my database. Then I get events with up to 20mb. Would it be possible to send records that have been...
Using the ServiceBrokerListener in a Windows Service, it appears that it only seems to fire one TableChanged event and then doesn't trigger any further updates, is my setup correct? private...
I'm trying to use your library and push changes using signalR but it's not triggering the changes any idea why? getting following error > System.AggregateException: One or more errors occurred....
Hi, Do you have any guidance for reacting to a lost connection with the server or restarting the sql server instance? In my experience, it fails silently, without any feedback,...
If the ServiceBroker is not enabled or the database is not trustworthy, the permissions stated in code are not sufficient. The SQL_FORMAT_INSTALL_SEVICE_BROKER_NOTIFICATION does not run successfully, because it trys to...
I need to return the results of a query when an item is inserted rather than the row data. I can create a trigger that would do this but the...
I am using SqlDependancyEx and get row data back with row that has been updated. Is there a way to find which column has been updated?
Metadata
Owner
Metadata
Component which receives SQL Server table changes into your .net code.