Invalid column name 'RowTimestamp'. In Snapshot Replication(SQL Server2008)

[SESumit]

I am implementing Snapshot Replication.I have two server ServerA(SQLServ er2008) and ServerB(SQLServ er2008).ServerA is Configured as Distributor as well as Publisher and ServerB is Subscriber.
Snapshot with all articles generated successfully.Bu t when i view synchronization status. Message detail are as:

Invalid column name 'RowTimestamp'.

I also tried to set Convert TIMESTAMP to BINARY=true of all articles property.But same issue.
Actually RowTimestamp is a column of my tables with timestamp datatype.
Help???

[ck9663]

The error seems to be not related to the column data type, but the column itself. Try dropping the snapshot and recreate it.

Good Luck!!!


~~ CK

[roshan ban]

I think that there is a mistake in spelling of your column name or probably the size of the field is to small to store your data

[SESumit]

Thanks Mr Roshan and Mr ck for your reply.
One thing I find in replication That when I select only Tables of Server A and Generate Snapshot Then Sync going ok to Subscriber(Serv erB).But when I select Tables,Procedur e,Views then Snapshot with all articles generated successfully.Bu t when i view synchronization status. Message detail are as:

Invalid column name 'StatSerialized ItemSummary'

Actually StatSerializedI temSummary is a column of my table.
I already tried dropping the snapshot and recreating the same.But same issue.
Help??

[ck9663]

Could be one of your view is not updated. A view should be referring to an existing column in an existing table.

Good Luck!!!


~~ CK

[SESumit]

I also think so.But What is the solution of this issue.
Is replication only used in scenario of Data Sync From One Server To Another Server.
Because in case of Views,Procedure s it creates error.