SCROLL_LOCK With Cursor in SQL Server

Hi Vipendra,

SCROLL_LOCKS - Specifies that cursor will lock the rows as they are read into the cursor to ensure that positioned updates or deletes made through the cursor will be succeed.

Please refer the below link

http://www.databasejournal.com/features/mssql/article.php/1439731/Using-SQL-Server-Cursors.htm

Thanks

The SCROLL_LOCKS option should be used if you want positioned updates or deletes made through the cursor to be certain to succeed.

However, you can't use this option in combination with the FAST_FOWARD option.