DECLARE @LastAccess DateTime DECLARE @Numero Int SET @LastAccess='2014-10-10 21:07:45' SET @Numero=24349 UPDATE Member SET LastAccess=@LastAccess WHERE Numero=@NumeroThis update on the Member table can only be done by one person. So, there cannot be two updates done on that record at the same time. Why do I end up with a deadlock on some isolated situations?