Cheers Steve/Nigel

Flags it is then.

Regards

Chris

Although sp_locks does give the lock details how can I determine which record is actually being held by the process. The resource attrib. does indeed provide the rid but how...