sql server replication: Explicit Insert for Timestamp Column in Microsoft Replication -- sql server replication

Explicit Insert for Timestamp Column in Microsoft Replication

Joy
8/26/2006 11:25:01 AM

sql server replication: Hi all,
I am writing a Insert trigger but to my dismay it is not able to insert
explicitly into columns of type Timestamp.

Please let me know the work around for this.

I am posting the question in this forum because i know Microsoft Replication
takes care of this problem well, so if anyone of you know how replication
takes care of this problem then please let me have your feedback at the
earliest.

regards,

Re: Explicit Insert for Timestamp Column in Microsoft Replication

Hilary Cotter
8/26/2006 6:59:48 PM

The are not handled in replication.

Refer to

http://msdn2.microsoft.com/en-us/library/ms151206.aspx

For transactional replication they are recalculated for the subscriber.

In some cases you can replicate them as varbinary(8) or binary(8) and get
the same value on both sides, but then you lose the rowversion property on
the other side.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]