"Hilary Cotter" wrote:

> Actually the timestamp column is replaced with a varbinary(8) column on the
> subscriber. If you want to keep a timestamp column on the subcsriber you
> must edit the update and insert proc to comment out the timestamp column.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html

"Phill Anderson" <PhillAnderson@discussions.microsoft.com> wrote in message
news:A93B0F73-1B5D-4865-9C04-F363FD5A07D8@microsoft.com...
> I'm trying to use transactional replication between two Sql2000 sp4
> servers.
> Updates are failing, on the subscriber, on tables with the timestamp
> column.
> I'm using sp_scriptdynamicupdproc to create the dynamic update stored
> procedures. It is adding a timestamp column, to update, to the stored
> procedure that it outputs.
> I thought that the timestamp column was ignored in this version of sql
> server.
>
> Is there a way to make it so it does not add the timestamp column in the
> update statement?
>
> -Phill Anderson

"Phill Anderson" <PhillAnderson@discussions.microsoft.com> wrote in message
news:C2373F51-3410-4CC4-8525-2C0E795A2FA4@microsoft.com...
> Where in the update and insert proc's do I comment out the timestamp
> column?
>
> -Phill
>
> "Hilary Cotter" wrote:
>
>> Actually the timestamp column is replaced with a varbinary(8) column on
>> the
>> subscriber. If you want to keep a timestamp column on the subcsriber you
>> must edit the update and insert proc to comment out the timestamp column.
>>
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>
>

"Hilary Cotter" wrote:

> In the subscriber you will find procs of the form sp_MSins_ArticleName and
> sp_MSupd_ArticleName
>
> open these procs, for the insert proc you will find a parameter like this
> @c3 binary(8). Note that on your proc it could be a different number, but
> note the number which has the binary(8) data type.
>
> Then in the insert statement remove the reference to the timestamp col, so
> something like
>
> insert into "TimeStampTable" ("pk", "charcol", "timestampcol") values (@c1,
> @c2, @c3)
>
> would become
>
> insert into "TimeStampTable" ("pk", "charcol") values (@c1, @c2)
>
> You would do something similar for the update proc.
>
> --
> 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