Hi,

When detaching my db a msg came back skating that I have over 300
connections to it. I know at the moment I was the only one connected so, for
some reasons, user process ids are not recycled (or eliminated) when the
user disconnects from the db. Is this normal? If not, how do I ensure that
such ids are eliminated automatically?

TIA

Mike

One possibility is application pooling. Normally a good thing, however,
users may be using Windows Authentication (or unique SQL authentication),
and the application pool is configured to hold a minimum number of
connections for an unlimited time duration.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Mike_T" <nospam (AT) yahoo (DOT) com> wrote