Hi, Im using building a Windows app which uses SQLDependency with SQL Server 2005 express edition.
When someone update/inserts/deletes a row the app is notified this works great.
But if the is idle for a couple of minutes it stops working.
Im not sure but i think this because the connection to the SQL server timeouts?
This app will be running for several days, what would be the best solution to still have SQLDependecy events working during this time?