transaction problems

  • Thread starter Thread starter Smokey Grindle
  • Start date Start date
S

Smokey Grindle

I am having wierd transaction problems where the transaction holds a lock in
SQL Server 2005 even after i perform the transaction.commit... anyone know
why ADO.NET would be doing this? this is a sqltransaction object that i am
working with.. thanks
 
Hi Smokey,

You are probably doing something wrong.
What does your code look like?
 
One way to troubleshoot these problems is by using a Profiler trace to
see the commands that are being sent to SQLS. Judging from the
information you have provided about locks being held, it looks like
SQLS has not actually committed the transaction.

-Mary
 
Back
Top