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
Solved

SQLDependency and connection timeout (I think).

Posted on 2009-05-13
1
908 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
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

765 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