>Watch out for connection pooling.

Hi Mike.

Tell me more. Bonnie and I have been scratching our head on this issue. Is the "pooling" done on the server? IOW, I issue a SqlConnection.Close(), but my little SP still shows a process associated with that connection. If the pooling is done on the server, is there any way to distinguish between an active connection and a pooled connection?