0 Replies Latest reply: Aug 2, 2013 7:58 AM by ma*437138*to RSS

    DbAdapter (nolock in merge operation)

    ma*437138*to

      Hello,

       

      I'm currently with performance problems when I do various operations on a SQL Server 2000 using a dbAdapter(merge operations).

      I did some analysis in the database and realized that I am having lock in "select" operation, and I have to wait for the "update". How can I add the command "nolock" at the end of this query?

       

      Thanks

      Zanatto