>This command gives a deadlock error about 3 times out of 50000 hits:
>
>

>DECLARE @NoMember Integer
>DECLARE @LastAccess DateTime
>
>SET @NoMember=64631
>SET @LastAccess='2009-02-11 11:46:55'
>
>SELECT Member.Numero,Member.Nom,Member.Prenom,Member.LastAccess
> FROM (SELECT Monitor.NoMember2 FROM Monitor WHERE Monitor.NoMember=@NoMember) Temp
> INNER JOIN Member ON Temp.NoMember2=Member.Numero 
> WHERE Member.LastAccess>=@LastAccess ORDER BY 2
>

>
>This line also executed within about 0.00 second. So, what can cause this behavior?

What would happen if there is no NoMember = @NoMember in Monitor or too many of them?