hi, (i am Using windows 2008 ,windows xp and sqlserver 2005 ,2008)
i have to put some data from one sqlserver to other sqlserver instence, both are kept geographicall seprated.
so because of datetime sync problem i have made the data transfer job with out datetime dependency.
but due to some restrictions for timebeen(temporary basis), i have to compare date time
of both the servers and put some records based on datetime comparision.
both sqlserver sync data using wcf and webservices.
I wanted to know , is it possible to keep the same date time at two different geographicaly separated computers, like using timezone settings, or there will be some difference in time, like few seconds, but it matters for me.
any link will be help full.