Unexpected Behavior on Connection Pooling Resets

sp_reset_connection does NOT reset the transaction isolation level to the server default from the previous connection's setting.

All stored procs should start with:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

or whatever is appropriate for that proc.

Thanks to aspiring geek, Jimmy May for this tip.  Details at

http://blogs.msdn.com/jimmymay/archive/2009/02/02/sp-reset-connection-does-not-reset-transaction-isolation-level-unexpected-behavior-by-design.aspx