Sorry for the horizontal lines. I am new in this blog - I thought that hr would give me a line break, and by the time I was done composing...

Hi Gail,

---

No, I have no proof of page locking.

I have not considered read committed snapshot or snapshot isolation as I never used them before.

I read about snapshot isolation this morning,...

Thank you for replying to my question.

1. Update is as straight forward as it gets:

UPDATE dbo.Table_Name

SET

[Col2] = @Col2,

[Col3] = @Col3,

[Col4] = @Col4,

[Col5] = @Col5,

[Col6] = @Col6,

[Col7] = @Col7,

[Col8]...