transaction problems

[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

 

[Miha Markic]

Hi Smokey,

You are probably doing something wrong.
What does your code look like?

 

[Mary Chipman [MSFT]]

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