Thanx for your reply.

The problem is that, if i run:

begin tran

update...

sp_lock

I see, that the eXcluse lock remain on the key. but the profiler shows:

(#1. Lock:Acquired 0X057022AC04000000000 (customer Table lock) (IX)

#2. Lock:Acquired 0X0670B0270010000000 (Page...

I guess it can:

You can select SQL query analyzer selection, sql server trace table, workload file.

The easiest way to run it over on an entire sp: type "exec sp..."...

Thanks for your answer. You are right about the intent locks:

The single row update inducates 3 locks : table Intent eXclusive (IX), page Intent eXclusive (IX), and key (row) eXclusive...