>Well, if you remove NOLOCK hint you should get 1 row from all applications.
I don't understand. NOLOCK is used either at the application level and in SSMS. So, the command is the same. Also, I do not see the relation with NOLOCK as per the message I created.
This seems to be related to the milliseconds precision that differs from the application and when in SSMS. I have adjusted to rely on a primary key instead.