>In my BOL (SQL 2005) I see IdleConnectionTimeout, IdleOrphanSessionTimeout, MaxIdleSessionTimeout, MinIdleSessionTimeout properties. Does this mean the DBA can set a time that the connection in Evan's app would be closed? Sounds like your advice to check the connection and reconnect as necessary before running a query is a good one.
I was thinking more of a DBA forcing connections closed for backups or other DB maintenance tasks. And then there's my favorite, when some moron with a backhoe cuts the cable. Disconnects happen.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.