Comments by AVINASH NOWDURU (Top 1 by date)

@stanciu

Exception: "Uncommitable Transaction identified at the end of batch".

Scenario:

I am using XLOCK/UPDLOCK/ROWLOCK(tried taking one at a time) with READPAST hint. when i run the same query in the SQL managementStudio i get correct output, but when i call it from the code under Transaction scope i get the exception. I am also modifying a status field for each record to ensure to get distinct record.

My question is.. Does READPAST & XLOCK/UPDLOCK/ROWLOCK(tried taking one at a time) goes with System.Transactions.TransactionScope ?

Is there any other way to get 2 distinct set of records when i call a select SP asynchronously?