Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replication and time zones?

Author  Topic 

aiken
Aged Yak Warrior

525 Posts

Posted - 2001-12-12 : 00:48:08
I'm going to be using merge replication to connect a server in new york with one out here near san francisco.

I've got numerous tables and queries that use default values of getdate(). Is that going to screw me up? That is, if two events happen at the same physical (3 hour clock difference) time in the two places, will one entry be 3 hours ahead of the other?

Even if I get my own time zone issues sorted out, what will SQL think during conflict resolution?

How do people deal with servers in different time zones?

Thanks in advance
-b

   

- Advertisement -