I am using a table as a message queue and "signing up" for updates by using a SqlDependency. Everywhere I read, people are saying "look out for the limitations of it" but not specifically saying wh...

I am trying to integrate live updates in my ASP.NET WebAPI and I have hit a wall so to say. I have my application set up (using Angular on front end), and I've got it so when the page initially loa...

We are using SqlDependency in a .NET web app. Intermittently in production, we receive the following error when trying to call Start: NullReferenceException - Object reference not set to an instan...

i have an issue with SqlTableDependency. My Changed method is not invoked when i make insert/update/delete to desire table. OnStatusChanged event works OK. string conn = @"data source=secret serv...

I've got a table and a SqlDependency that is waiting for new inserts. OnChange fires as I need, but I don't understand if it's possible to get the row which cause the databse change. SqlDependen...

I have created a notification service using SqlDependency for notifying other services about the change in a particular table. This is done in the Windows Service template from Visual Studio. Hence...

I'm working with SQLDependency to notify me if there is a change in the Database. After Program Start-Up it works just fine. When I make a first change the Event fires. Wohoo... that's great. But...

It seems like a big use for SignalR Hubs is to display the actions of one client to all of the other clients. What I hope to use SignalR for is when a certain event happens in my server side code, ...

I was developing this application on VB.net 2010 and SQL 2008. I wanted the clients to be notified for updates on the db, and the application used to check the db for changes in the specified minut...

After bashing my head against a wall for the next few hours I've slowly started to realise where my problem lays, so let me give you a recap: I'm trying to change a website's string when a row gets...

We have a web application that consists of a a 3 layered back end (Controller/Biz/Data) with a UI. Our data layer is solely responsible for pulling the data out of the database instance (SQL), the ...

I have a web application that use a SQL Server database that is shared with others web applications (over which I have no control). I must know when any of the web apps makes changes to some tables...

I'm using SqlDependency to control my cache. I want to use it to monitor several tables (around 10). There should be one SqlDependency per watched table. Should I create for each of them code like...

I'm new to the concept of query notifications with SQL Server and it's going to take some time for me to wrap my head around it. My objective is to create a Windows service application that is no...

I am facing an issue while using SQL Server Notifications. I am developing a web application in ASP.net where one of the page needs to be notified about new entries in one of the tables in a SQL Se...

I've been using SqlDependency in a .NET 3.5 application for over 3 years without any problems. The scenario is as follows: Central windows service with a SqlDependency watching a table (let's cal...

I have an application running on a server which has a SqlDependency / query notification - monitoring changes on a table on a different server. It works fine until we reboot/restart SQL Server. Wh...

When I execute a query with a datetime column filter WHERE [Order].CreatedOn >= @CreatedOn using a SqlDependency, the change on data source fires the SqlDependency.OnChange event but the Sql...

I'm using the SqlDependency class and have been trying unsuccessfully to find a list of possible combinations of the Type, Source and Info properties of the SqlNotificationEventArgs object. This ...

I am currently working on an email application where I have to monitor the table for any new record inserts and send email notification for each row. Right now the changes (inserts) will be at low...

I have a mssql table that holds chat information. It has computed columns, has millions of rows and is being used/populated by an third party application. Now I want to use this table to show chat ...

Problem: There are a lot of different databases, which is populated by many different applications directly (without any common application layer). Data can be accessed only through SP (by policy)...

I have the following code that uses SqlDependency to monitor changes in one of my databases It works great, except every run it generates its own Queue/Service/Route with a guid in the database: C...

How do I clean up the SQL Server to get rid of expired SqlDependency objects? After I receive the event from the SqlDepedency object, I need to create a new one before I can get a new event. Howeve...

I'm trying to get the SqlDependency object to give me notifications, but so far I'm not able to get it working. the sql query that I'm sending is this: SELECT [SocialMedia].[dbo].[Items].[Id] FR...