Monika,

Actually If you really want to find out, you can check it yourself with filemon from www.sysinternals.com. It will tell you exactly what happens in this scenario.

Walter,

>I am curious about exactly when a row gets locked and when the table header gets locked under the follwing conditions:
>
>1 - Buffering set to 'Optimistic Row'
>2 - Many new rows appended to table
>3 - Begin transaction
>4 - Tableupdate
>5 - End transaction
>
>Thanks in advance for your help
>
>Monika