Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open cursor connections

Status
Not open for further replies.
WP

WP

Programmer
Joined
Nov 30, 1999
Messages
463
Location
CH
When my VB app crashes and I have open cursors then they are left open in SQL server.

Is there a property on connections that I can set that if a connection is idle for say 15 mins the it is dropped? Bill Paton
william.paton@ubsw.com

Check out
 
Status
Not open for further replies.

Similar threads

BxWill
  • Locked
  • Question Question
Create Non-XML Format File for Bulk Insert - Error: Could not open connection to Sql Server
Replies
1
Views
353
fredericofonseca
fredericofonseca
SaltyTheFrog
  • Locked
  • Question Question
Rework process not to use cursor
Replies
3
Views
375
gbaughma
gbaughma
javieret
  • Locked
  • Question Question
SQL SERVER 2016 - Properties TCP / IP - Open IPALL TCPPort 1433
Replies
0
Views
184
javieret
javieret
jchewsmith
  • Locked
  • Question Question
Open Query in MS SQL from MY SQL
Replies
1
Views
191
gbaughma
gbaughma
pabowen
  • Locked
  • Question Question
Accessing Nested JSON Array Data using OpenJSON
Replies
1
Views
737
jbenson001
jbenson001

Part and Inventory Search

Sponsor

Back
Top