Sp_reset_connection
Jan 19, 2004
hi,
I'm using DAAB with ExecuteNonQuery and ExecuteDataset and I watched the DB calls through sql profiler and I noticed that after each call appears a new one with exec sp_reset_connection.
Is that normal ? Does that means that the connection is returning to the pool ?
View 1 Replies
Nov 28, 2007
I'm profiling some SQL work from ADO.NET and I see a large number of sp_reset_connection but what I don't understand is how the SPID remains constant if the connection truly has been reset. Obviously it doesn't reset the SPID so what *is* going on? NB This is a number of ADO calls inside a System.Transaction.
View 16 Replies
View Related
