|
Posted by Greg D. Moore \(Strider\) on 11/30/07 21:02
"Neil" <nospam@nospam.net> wrote in message
news:8WT3j.25110$JD.20049@newssvr21.news.prodigy.net...
>
>> "Tony Toews [MVP]" <ttoews@telusplanet.net> wrote in message
>> news:ukbvk3dm2tn1opt3tbtbp1d561lvq062qs@4ax.com...
>>> "Neil" <nospam@nospam.net> wrote:
>>>
>>>>Well, unfortunately that doesn't seem to be the case. Individual
>>>>computers
>>>>vary from the server time by as much as 10 minutes! Is there some sort
>>>>of
>>>>setting to use to use the server time. Maybe I'll pass that along to the
>>>>admin and see if he implements it.
>>>
>>> BTW there are functions to also get the system time from a server and
>>> compare that to the time on the PC. You can use that to show the IT
>>> department.
>>>
>>> API: Retrieve NT Server's Time
>>> http://www.mvps.org/access/api/api0039.htm
>>>
>>> Tony
>>> --
>>> Tony Toews, Microsoft Access MVP
>>> Please respond only in the newsgroups so that others can
>>> read the entire thread of messages.
>>> Microsoft Access Links, Hints, Tips & Accounting Systems at
>>> http://www.granite.ab.ca/accsmstr.htm
>>> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>>
>>
>
> "Pieter Wijnen"
> <it.isi.llegal.to.send.unsollicited.mail.wijnen.nospam.please@online.replace.with.norway>
> wrote in message news:O6o2%23EyMIHA.2432@TK2MSFTNGP04.phx.gbl...
>> The command line (which should be included in the logon script) is:
>>
>> net time /DOMAIN:DomainName /SET
>>
>> HtH
>>
>> Pieter
>>
>
> Just to be clear, putting that into the user's logon script will set their
> PC's time to the server's time?
>
To the DOMAIN controller's time.
The SQL server (which in most cases is not a DC) should also synch to the
domain controller.
There's also a registry setting to force it to synch that can be set under
domain policies.
The only time I've had to do the net time /domain: in recent memory was when
the time of the client was so far off that it wouldn't log in properly.
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
[Back to original message]
|