S
S
serl2010-09-03 20:35:27
SQL
serl, 2010-09-03 20:35:27

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 question

Ask a Question

731 491 924 answers to any question