HI all 

I have transactional  replication,

The publisher DB contains table call Courser with timestamp column, this column values are unique for the publisher DB

The subscriber DB also contains same copy of data in publisher DB Course table, but the timestamp column values are different. 

So my problem is how can I keep this two tables (Course) identically, (same timestamp column vales in both table)

 NOTE: Publisher and Subscriber DB reside under two different SQL server instance.

Thanks and regards

IndikaD

There is an option in article properties (Under replication properties) which allows you to convert timestamp columns to binary. if you set it to true you can transfer the timestamp values.

 

 

---

G.R.Preethiviraj Kulasingham MCITP: DBA
http://preethiviraj.blogspot.com/
Plan Your Work and Work Your Plan!

HI Preethiviraj

Thank you for you'r reply , it's working as i expect 

 

Thanks

IndikaD(Virtusa Cop SL )