Memory Orphan Connections

Does SQL Server 2000 clean up broken or orphan connections
and lease their corresponding memory?
Is there a Microsoft Article that goes into this topic.
Thanks,
Mark P.Basically yes. When a connection is broken SQL Server will rollback any
open transactions for that connection and any memory used as such will be
available for use by other connections.
--
Andrew J. Kelly SQL MVP
"Mark P." <anonymous@.discussions.microsoft.com> wrote in message
news:34f501c49cfc$55623e50$a601280a@.phx.gbl...
> Does SQL Server 2000 clean up broken or orphan connections
> and lease their corresponding memory?
> Is there a Microsoft Article that goes into this topic.
> Thanks,
> Mark P.