SQL 2000 SP4 on Server 2003 SP1 not dropping connections

Sounds like you now using connection pooling which will always keep x many
connections to SQL Server even though the app closes the connection. This is
usually a desirable feature.


--
Andrew J. Kelly SQL MVP

"Brad Martin" wrote in message
news:1D06C303-485E-4843-9443-948FB9AB7B8E@microsoft.com...
> We recently upgraded our SQL 2000 SP3 instance (running on Windows 2000)
> to SQL 2000 SP4 running on Windows Server 2003 SP1. The migration went
> fine but we are now experiencing a problem where connections are not
> dropping once the application is finished with it. The application is a
> COM+ app making an ODBC connection, which then never closes. We are
> running a job that cleans up the connections, but we can't seem to find
> the reason why SQL is keeping the connections open in the first place.
> Any ideas or suggestions?
>
> Brad