Questions tagged [query-notifications]
52 questions
0
votes
1 answer
SQLDependency subscription not registered and Query Notification message has Source Statement and Info Set Options
I am developing an application with SQL Dependency feature.
When i execute the application, subscription was not registered.
and sys.dm_qn_subscriptions has no entry.
i used SQL profiler to trace the issue and i noticed that subscription was not…
Alagesan Palani
- 1,984
- 4
- 28
- 53
0
votes
0 answers
Query Notification and Sql Dependancy, Check most, Read least
I have a 'C#' Application consuming a 'Sql Server 2012' database. I am using a Sql Dependancy object to watch the changes in an important table, using Sql Server Query Notification technology. I am currently watching for the following query :…
Mahdi Tahsildari
- 13,065
- 14
- 55
- 94
0
votes
2 answers
SignalR and Query Notifications in sql
I'm new in signalr, and reading and surfing the net I found this incredible (I think) tutorial
http://techbrij.com/database-change-notifications-asp-net-signalr-sqldependency.
But I have a problem, when I run the statement GRANT SUBSCRIBE QUERY…
user3919607
0
votes
1 answer
Network SQL Database SQL Dependency on C# App Issue
I have used query notification on my c# application successfully using local database. However, changing the connection string to my actual database (not local) results in an error. Note that both databases are identical + queues and services etc.…
Cogent
- 404
- 7
- 16
0
votes
1 answer
Service broker - conversation handle not found messages in SQL Server error log
Many threads opened on this topic, none seem to have an answer for my problem so i am going to give it a try..
System :
Windows Server 2012
SQL Server 2012 Enterprise edition
Problem :
We are using SQLDependency to enable use of query…
Doron
- 21
- 3
- 6
0
votes
1 answer
How do you properly call "End Conversation" with a multiple result query (SQL Service Broker)?
I am using the Service Broker on SQL Server 2008 R2, and I am registering a stored procedure that has multiple select statements like this:
SELECT
A.Date
,A.Id
FROM
dbo.Appointment A
SELECT
P.Name
FROM
dbo.Person P
When I…
lehn0058
- 19,977
- 15
- 69
- 109
0
votes
1 answer
How can I write a query for notification request from application to Database?
This is my perivous question. about how to push the data from database instead of application pull data.
After went through the link and the documents I come to know that I need to write a query in application side for notification request then the…
niren
- 2,693
- 8
- 34
- 58