Solved

SQLDependency and connection timeout (I think).

Posted on 2009-05-13
1
939 Views
Last Modified: 2012-05-06
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?
0
Comment
Question by:o3h
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 13

Accepted Solution

by:
St3veMax earned 250 total points
ID: 24372472
Check your database is not in 'AutoClose' as this will close the database after a period of inactivity.

To do this, Right click on your database in Management Studio, hit properties and look at Options for AutoClose; Should be set to false.

HTH
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question