>

>SELECT * from myTable WHERE ID = @ID WITH (READPAST)

>
>
>That's a good guess....but a READPAST essentially ignores a row where it can't get a shared lock.
>
>Again, in this situation, if a shared lock could not be obtained, we want the last good committed version.
>
>Give you a hint....think "camera"

snapshots?