Asp.net,C#.net,Sql Srver problems and solutions Blog

http://msdn.microsoft.com/en-us/library/ms178604.aspx http://davidhayden.com/blog/dave/archive/2006/04/29/2929.aspx http://davidhayden.com/blog/dave/archive/2006/04/29/2929.aspx http://www.dotnetspider.com/resources/18424-Using-SQLCacheDependency-Class-ASP-Net-SQL.aspx http://www.wrox.com/WileyCDA/Section/Using-the-ASP-NET-2-0-SQL-Server-Cache-Dependency.id-306459.html troubleshooting-sqlcachedependency http://developmenttips.blogspot.com/2009/01/troubleshooting-sqlcachedependency-in.html checking broker was enabled or not select is_broker_enabled from sys.databases where database_id=db_id() creating end points: USE master; CREATE ENDPOINT BrokerEndpoint STATE = STARTED AS TCP ( LISTENER_PORT = 4022 ) FOR SERVICE_BROKER (AUTHENTICATION = WINDOWS) GO use SAIDASARI; ALTER DATABASE SAIDASARI SET ENABLE_BROKER; Identifying running queries sp_Who killing running process kill 55

https://help.maximumasp.com/KB/a384/how-to-configure-sql-cache-dependency-support-your-aspnet-20.aspx

http://msdn.microsoft.com/en-us/library/ms178604.aspx