Answer the question
In order to leave comments, you need to log in
Cant with Asp.net and SqlDependency
Sql Server 2005 and ASP.NET 3.5
The problem is known and related to the rapid filling of the sequel erorlog with messages like
The query notification dialog on conversation handle '{F3EB22A6-CDB6-DF11-9BF1-003048CEA3F1}.' closed due to the following error: '<?xml version="1.0"?> -8490
<Description>Cannot find the remote service 'SqlQueryNotificationService-558d19fc-a13c-4839-a334-70ec4eaaff90' because it does not exist.</Description>' .
Google leads to two tips - do SqlDependecy.Close only in Application_End (that's what I do), this will reduce the number of collisions and roll some patch that came out after the third service pack, which I did not find in the public domain.
Has anyone tried to solve the problem perhaps more beautifully?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question