Stack Overflow
Stack Overflow

Questions tagged [query-notifications]

52 questions
2
votes
1 answer

How the SQLDependency class is taking advantage of the SQL Service Broker feature?

Since I couldn't find any decent resource to provide me with this kind of explanation or some graph, after accumulating sufficient knowledge about this topic, I decided to create one by myself and to post it as an answer this question. Hope it will…
Yair Nevet
  • 12,725
  • 14
  • 66
  • 108
2
votes
0 answers

Listening for DML queries on a MySQL database in Golang

I am using go-sql-driver/mysql driver for connecting to a MySQL database in Golang. I wonder is there a way to listen for DML queries on the database such that the client gets notified/triggered when any such query occurs. I am using the inbuilt…
Avi
  • 1,341
  • 1
  • 18
  • 28
2
votes
1 answer

cx_Oracle Continuous Query Notification

i'm using an Amazon Work Space and i use a VPN to connect via SSH Ubuntu 16.04 instance. I use python to do a connection an Oracle Database 11g, i need to use cx_Oracle Continuous Query Notification and i founded this code looking on the internet…
Carlos Manrique
  • 21
  • 3
2
votes
0 answers

SqlDependency vs constant polling of a SQL Server database

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 rate but eventually it will become more. Initially…
itsfighter
  • 167
  • 4
  • 15
2
votes
2 answers

Is it possible to make count Query for SQl Dependency?

Concerning SignalR and SQL Dependency, is it true that the Query Notification can't use aggregate function like count(*)? Do one have another way or an idea for create query that contain aggregate function ?
Handaru Eri Pramudiya
  • 135
  • 1
  • 11
2
votes
0 answers

How to manually send query notification using service broker?

according to limitations of query notification by using SqlDependency, How can we send query notifications using service broker SEND statement in a way that .net SqlDependency can catch and parse it as a valid message it needs? I mean something like…
Hamed Zakery Miab
  • 738
  • 2
  • 12
  • 34
2
votes
1 answer

Query Notification using Sql Dependency - Stops detecting changes

I am using SQL server tables to act as a queue in my applications. Im using Query Notification using SQL Dependency, notably Jeremiah Gowdy's awesome implementation used in this blog post.…
gorillapower
  • 450
  • 6
  • 15
2
votes
1 answer

How to figure out which SQLDependency triggered change function?

I'm exploring query notifications with the SQLDependency class. Building a simple working example is easy, but I feel like I'm missing something. Once I step past a simple one-table/one-dependency example I'm left wondering how can I figure out…
EBarr
  • 11,826
  • 7
  • 63
  • 85
1
vote
1 answer

SQL Query Notifications - UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'

My question is somewhat related to UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER' . I am using SQL Query Notifications to enable caching for my application from the database and have run into a strange…
Maxim Gershkovich
  • 45,951
  • 44
  • 147
  • 243
1
vote
2 answers

Cannot drop SqlQueryNotificationService queue

While trying to drop the SQL service broker object, I come accross this error The queue 'SqlDependencyStarter.SqlQueryNotificationService-e1304de0-fb30-4009-b3fb-478c34acc40a' cannot be dropped because it is bound to one or more service. But…
Deepanshu Kalra
  • 419
  • 2
  • 9
  • 23
1
vote
1 answer

query notification

could someone pls tell me the version requirements for query notification? we are running sql server 2008 and use ODBC 3.0 but are still on visual studio 6. on compile some of the ODBC parameter (ex: SQL_SOPT_SS_QUERYNOTIFICATION_OPTIONS) are not…
user456339
  • 11
  • 1
1
vote
2 answers

SQL Server Query Notifications using stored procedure

I am trying to implement query notifications for a current project. I'm implementing query notifications using SqlDependency. I'm able to get the code to work when I do inline SQL for the query directly in the Ado.net command, however, when I put…
Michael Wilson
  • 1,207
  • 2
  • 12
  • 16
1
vote
1 answer

SqlDependency when SQL Server stops

I am using SqlDependency to get change notifications from SQL Server. If the SQL Server is restarted, the notifications are resumed with it, but if SQL Server is stopped and then started then it looses the dependency. Is this the expected…
Marshal
  • 6,551
  • 13
  • 55
  • 91
1
vote
1 answer

SQL Sever 2014 Query Notifications in C++ with ADO.NET libraries

I have a C++ application that has to react to status changes that are kept in an SQL database. They have to react in real-time, and currently this is done by polling. However the real-time response time I need is overloading the database. I have…
Raiden616
  • 1,545
  • 3
  • 18
  • 42
1
vote
1 answer

SqlCacheDependency remove callback fires directly after Cache.Add

I have a problem with SqlCacheDependency that I cannot wrap my head around. The CacheItemRemovedCallback will fire as soon as I add something to the cache when using a query for notification (it works when I am using databaseEntryName and tableName…
Philip
  • 33
  • 4
1
2
3 4