Monday, February 20, 2012

old connections

All,
Sql 2000 sp3, Server 2000 sp4
I have a cold fusion front end that hooks to my db and it
never seems to close a connection. The problem has only
gotten worse in the last 2 weeks. I go through and kill
everything older than a day, going by last batch date. Is
there a clean up proc available? Anyone else have this
problem, resolutions?
Thanks,
GaryWhen you say close a connection , do you mean a transaction? What's the
behaviour you see on the SQL side?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

No comments:

Post a Comment