Posted by Matik on 04/27/07 13:59

> > The getdate() is not taking the current system time, only the buffered
> > SQLServer system time.
>
> I like to stress that is my own speculation of how the internals work.
>
> > That means as well, that the time between changing system time,
> > writing into log (application) and calling procedure in DB, until this
> > position where the getdate() is called, MUST be shorter than a maximum
> > time of 3.33 ms.
>
> If my theory is correct, yes, this appears to be a correct conclusion.

I was thinkig about one more thing ...
Is there any way, to force sql server to refresh it's time?
Let's say, that by the procedure call, I will force him, to refresh
it's time ... will it be possible somehow?

Matik

• Next in forum: Re: Populate a Table with Stored Proc.
• Prev in forum: Re: Trigger: To fill another Database with using Stored Procedures of the other Database
• Thread view: Re: getdate() problem: where is the time taken from ?

[Reply to this message]