Posted by Erland Sommarskog on 07/30/05 01:54

NotAGuru (notaguru@hotmail.com) writes:
> Thanks! I looked at errors log too - there are no errors.
> The code would not tell you anything it is just an update statement but
> here it is:

Thanks for the code. The benefit I have from it, is that I can see
that there is nothing hiding in it. Then again, this also means that
I don't very many more suggestions. Blocking is the only thing I can
think of, but you seem to have ruled that out. And it should lead to
the connection being severed.

I assume that the .Net code uses ExecuteNonQuery to run the query?

And just to check - there are no triggers on the table, are there?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]