locked
Transaction isolation level read uncommitted RRS feed

  • Question

  • will the setting of transaction isolation level to read uncommitted at procedure level works for dynamic queries (called within the proc) also?

    let say if i have proc SP1 and in very beginging of the sp1 i set the transaction isolation level to read uncommitted.

    Then i call a dynamic query without nolock or  transaction isolation level to read uncommitted then what will be the  transaction isolation  for the dynamic query?

     


    ~Technology Analyst~
    Thursday, January 6, 2011 7:04 AM

Answers

  • It will be read uncommitted.

    Tom

    • Marked as answer by Ai-hua Qiu Thursday, January 13, 2011 9:04 AM
    Thursday, January 6, 2011 7:11 AM