Time synchronization
Whenever you use replication that requires time stamp, time stamp with a stored procedure, or delete wins conflict resolution, you must synchronize the operating system times of the database servers that participate in the replicate.
All timestamps and internal computations are performed in Greenwich Mean Time (GMT) and have an accuracy of plus or minus one second.
To synchronize the time on one database server with the time on another database server, use one of the following commands, where hostname or servername is the name of the remote database server computer.
- UNIX™
rdate
hostname- Windows™
net time \\
servername/set