My profiler trace shows that exec sp_reset_connection is being called between every sql batch or procedure call. There are reasons for it, but can I prevent it from being called, if I'm confident t...

Trying to understand what Sql Profiler means by emitting "sp_reset_connection". I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed, RPC:Completed ...

We have a web service coded in C# that makes many calls to MS SQL Server 2005 database. The code uses Using blocks combined with C#'s connection pooling. During a SQL trace, we saw many, many call...