When neither FORWARD_ONLY nor SCROLL is specified, FORWARD_ONLY is the default ... SQL Server does not lock rows as they are read into the cursor. It instead uses comparisons of timestamp column ...