Time synchronization is usually done by the Windows Time Service. By
default, time synchronization is done using the standard AD hierarchy.
Clients and member servers get their time from a domain controller in their
domain. Domain controllers get their time from a domain controller in their
parent domain. Forrest root domain controllers are ultimately used as the
time source and use either a hardware clock or NTP source.
> How can i synch the time bet the client & the server ?
One method to resync the time is with the w32tm.exe: w32tm.exe /resync
Another method is with the NET TIME command: NET TIME /DOMAIN:MyDomain /SET
> and prevent it from happening again
See the TechNet article below for a discussion of the Windows Time Service:
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/TechRef/a
0fcd250-e5f7-41b3-b0e8-240f8236e210.mspx

Signature
Happy Holidays
Dan Guzman
SQL Server MVP
> Hi ,
>
[quoted text clipped - 8 lines]
>
> tks & rdgs