Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Hi Mike,
I'm not using transactions at all. What bothers me most is that the problem doesn't occur all the time (with the same data).
I will have a look at sp_who and sp_locks.
Thanks,
Martin
>>No, I don't get an error.
>
>Maybe there's a logic issue somewhere? On a long shot, are you using savepoints from distributed transactions?
>
>>> I'm not sure how to determine if the connection is blocked.
>
>Use sp_who and look for a value in the BLK column. Use sp_locks for more details on the locks currently held on various objects.
>
>-Mike
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement