>>According to the execution plan, SQL engine runs 2 separate queries and than merges them. I would bet that the execution plan for a JOIN query would be the same or close. IOW, I don't thibnk that switching to exists changed anything.
>>

>>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=@NoMember
>>

>>
>>I 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?
>
>Ok, I see. Let me check that. That's probably what causes this. I also got that one one more time today and the traffic was low. So, it is certainly related to another hit that is affecting this. I will let you know.

UPDATE or INSERT into these two tables happening in exactly the same time as you do SELECT-SQL.