SELECT Member.Numero,Member.Nom,Member.Prenom,Member.LastAccess FROM Member WHERE Member.LastAccess>=@LastAccess AND -- And SELECT Monitor.NoMember2 FROM Monitor WHERE Monitor.NoMember=@NoMemberI don''t see anything wrong with query itself. Are there any other SQL statement in your system that uses those 2 tables and could cause the deadlock?