Hi all, I have just inherited a framework written in C# which is used
to store objects into a database via ADO.NET.
When I did a bulk insert the database started to run slow I logged into
MSSQL enterprise manager and looked at the running processes under
Management-->Current activity-->Process Info. The resulting screen shot
is shown below (sorry about the popups from the image hosting page!)
http://img153.imageshack.us/my.php?image=errorxp3.jpg
If I view the last command on each of these it is "COMMIT TRANSACTION".
What usually causes these sorts of problems???
TIA
Markus