Invalid column name 'is_not_for_replication'.

Question

Post reply

Invalid column name 'is_not_for_replication'.

iBar

SSCertifiable

Points: 5872
More actions
June 24, 2010 at 3:05 am

#220348

ello,
"SQL Server 2005 64Bit with latest SP"
Already Synchronizing some subscriber with this publication. Created a cooy of Exisiting DB and added as a new subscriber. Subscription created successfully. however when i check the replication monitor its giving following message
"Invalid column name 'is_not_for_replication'. (Source: MSSQLServer, Error number: 207) Get help: http://help/207"
Checked in the new subscriber table, and it has NOT created "msrepl_tran_version" which is available in same table in other already created subscribers.
Check the DB, table and column collations, and that is exactly same.
So what is this message ?
The one problem/difference that i can see is that these tables PK is identity column. So replication setup is usually supposed to add new column "msrepl_tran_version" which is not there in the problem scbscriber DB tables.
Could find Any relavant material/help yet...
Thanks.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

iBar SSCertifiable Points: 5872 More actions · Answer 1

Hello Experts:

Following are the steps:

1. Starting Agent

2. Initializing

3. Invalid column name 'is_not_for_replication'.

Following is the exact error message:

Command attempted:

if object_id('sys.sp_MSrestoresavedforeignkeys') < 0 exec sys.sp_MSdropfkreferencingarticle @destination_object_name = N'tblTable', @destination_owner_name = N'dbo'

(Transaction sequence number: 0x0010F340000036A2007B00000000, Command ID: 5)

Error messages:

Invalid column name 'is_not_for_replication'. (Source: MSSQLServer, Error number: 207)

Get help: http://help/207

Invalid column name 'is_not_for_replication'. (Source: MSSQLServer, Error number: 207)

Get help: http://help/207

Kindly reply something ?

Cheers.

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 2

Bill Gates-870674 (6/24/2010)
ello,
"SQL Server 2005 64Bit with latest SP"
Already Synchronizing some subscriber with this publication. Created a cooy of Exisiting DB and added as a new subscriber. Subscription created successfully. however when i check the replication monitor its giving following message
"Invalid column name 'is_not_for_replication'. (Source: MSSQLServer, Error number: 207) Get help: http://help/207"
Checked in the new subscriber table, and it has NOT created "msrepl_tran_version" which is available in same table in other already created subscribers.
Check the DB, table and column collations, and that is exactly same.
So what is this message ?
The one problem/difference that i can see is that these tables PK is identity column. So replication setup is usually supposed to add new column "msrepl_tran_version" which is not there in the problem scbscriber DB tables.
Could find Any relavant material/help yet...
Thanks.

Hello,

How did you create subscription ? using GUI or TSQL.

check if the subscription is added or not. Ref: http://msdn.microsoft.com/en-us/library/ms190493%28v=SQL.90%29.aspx

HTH,

Cheers !

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

iBar SSCertifiable Points: 5872 More actions · Answer 3

Adding using SSMS GUI.

Subscription created successfully.

I can see the subscription under publication and under local subscription as well. BUT replication monitor is giving that error message.

SO?