December 19, 2008 at 4:50 am
Hi,
I'm currently working on synchronizing two databases on the same SQL Server 2005 instance.
One database publishes and distributes an article.
The other database is the subscriber.
One table contains a datetime column. Once records in this tables are synchronized on the subscriber, there is an offset of 1 hour.
e.g.: on the publisher the datetime is 2008-12-19 00:00:00.000
whereas on the subscriber the value is 2008-12-18 23:00:00.000
I have been searching the internet for similar posts. There are a number, but no answer yet that helps me out.
Thank you in advance!
Regards Roeland Verbeek
December 19, 2008 at 6:57 am
Are all the databases are on the same server? If they was a different server involved I'd blame it on the server time zone setting, but I don't have any explanation if you are not going to a new server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 27, 2009 at 8:35 am
------- SOLVED ---------
See
http://p2p.wrox.com/sql-server-2005/72103-sql-server-2005-replication-shifts-datetime-fields.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply