September 8, 2008 at 3:22 am
Hi,
I've just started having a look at Transactional Replication in SQL Server 2008 (porting over a SQL Server 2000 database). On the same server I set up a Publisher (Push Transactional Replication) and then associated a Subscriber databse. For the test I just replicated every table in our application and a few of them are new and they didn't have the msrepl_tran_version column. In SQL Server 2000 this column was automatically created if it didn't exist however this time the column wasn't created however replication worked fine.
I just can't figure out if msrepl_tran_version is no longer needed in SQL Server 2008.
The BOL enter for the function "HasRowVersionColumn" tells me:
If HasRowVersionColumn returns FALSE, the msrepl_tran_version column is added to tables in transactional or snapshot publications that allow updatable subscriptions.
But it also says:
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Any help would be appreciated.
TIA, Peter
October 27, 2008 at 3:35 am
Hi,
I have to set up a transactional replication.Publisher in one server and distributer and subscriber on the other.I am trying to use horizontal filter(with date in where clause) and 'Donot change the table' in subscriber option.
My intention is when Publisher will be archived of the old data ,it will not archive the data in subscriber.It worked once but now it is giving 'Invalid Column name the msrepl_tran_version' or cannot insert primary key in the table for which i put filter and donot change option.
Please give me some inputs.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply