SQL Server 2005 Notification Services with ASP.NET 2.0
-
Dear all, I am creating a ASP.Net application to simulate SQL Server 2005 Notification Services. Query Notification will be automatically created when using SqlDependency. But,When I execute the application I get the following message in the profiler trace. -------------------- subscription fired0<qn:QueryNotification xmlns:qn="http://schemas.microsoft.com/SQL/Notifications/QueryNotification" id="0" type="subscribe" source="statement" info="invalid" database_id="0" sid="0x339E5CD52F1FEB419D35D66253BDD553">qn:Message00000000-0000-0000-0000-000000000000</qn:Message></qn:QueryNotification>75BC3CE3-9DFD-DD11-8F07-00145EBC7544 -------------------- In the above trace, type="subscribe" source="statement" info="invalid" is the error. Please help me how to rectify this. I hope that the subscription is not registering. Thanks in advance. Senthil