I believe that the NOLOCK hint still requires at least a schema stability lock on the target table. The real benefit of using a NOLOCK hint is that you...

It looks like the problem is in the [SP_TD_GEN_NEXTID] procedure. If it is getting the next ID by getting the current ID from a table, and is not locking...