SQL Server Developer Center >
SQL Server Forums
>
SQL Service Broker
>
SqlDependency works perfect but sometimes...
SqlDependency works perfect but sometimes...
- I have a problem with the SqlDependency object.
It appears to be working for days and suddenly it stops working for some reason. When I restart the NT service which is waiting for the data it works again for days...
What is the possible reason?
1. Running SQL Server 2005 SP2 (Can't install SP3 due to other db's).
Answers
- Are you sure you're re-registering the query notification under all
conditions you're application might run into? You can use the DMVs to query
SQL Server as to status, or run a SQL Profiler trace to keep track of what
QN is doing. If you only trace the QN events, it could be a fairly
lightweight trace to run.
Bob Beauchemin
SQLskills- Marked As Answer byNai-dong Jin - MSFTMSFT, ModeratorTuesday, November 03, 2009 3:03 AM
All Replies
- Are you sure you're re-registering the query notification under all
conditions you're application might run into? You can use the DMVs to query
SQL Server as to status, or run a SQL Profiler trace to keep track of what
QN is doing. If you only trace the QN events, it could be a fairly
lightweight trace to run.
Bob Beauchemin
SQLskills- Marked As Answer byNai-dong Jin - MSFTMSFT, ModeratorTuesday, November 03, 2009 3:03 AM
