When I perform an INSERT or an UPDATE followed by a SELECT on these inserted/updated rows, SQLServer seems to be unaware of the changes or additions made 1/10th second earlier using the same connection. This behavior occurs occasionally on a client's site.
Is there someone who can explain or has experienced the same behavior of SQLServer 2000?