There is another twist to this story. The value that the system timer presents to the callers is sometimes interpreted differently by the callers. I run some tests where I read the system time in a .NET app, called a SP to store it in the DB where one of the fields had a default of getdate().

The explicitly entered time value received from the .NET was almost always different by 3 ms then the time generated by the getdate(). The funny part is that the .NET time value was 3ms later then the getdate() value. It looked like the SQL read the time before I decided to insert the record.

PS.

Jeff,

It is Jacek not Jack. 😉