Added the ROWLOCK hint to the sql transport in order to make sure that we
never take a table/page lock. Closes #1093