Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 replication article issues

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-14 : 10:53:22
marlon writes "im planning to implement a replication in my sql server 2000 and we're at the last part of our development phase and my problem is transactional replication add timestamp column and it will be a huge problem for our development team, can i still use transactional replication with immediate update without using timestamp im my columns? or use the timestamp columns but wont affect the system we develop, by the way im going to use replication for my standby server. ;) thank you very much.

marlon"

PiecesOfEight
Posting Yak Master

200 Posts

Posted - 2001-12-14 : 11:20:03
From BOL:

Instead of using a timestamp column to track updates (as in SQL Server 7.0), a uniqueidentifier column, added automatically to any tables used in the publication, is used to track updates. The addition of this column requires INSERT statements to have column lists.

Is it a problem having the uniqueidentifier column added?

Go to Top of Page
   

- Advertisement -