Hi, Nandy

Perhaps you should modify your cursor query into this.

declare test_cursor cursor for

select * from test WITH(NOLOCK)

to be able to make alteration to the table