Replication Error: Invalid Column

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 2005 Forums

SQL Server Administration (2005)

Replication Error: Invalid Column

Author

Topic

amsqlguy
Yak Posting Veteran

89 Posts

Posted - 2009-07-10 : 17:37:15

Guys,

I am getting the following error in my transaction replication with pull subscription.

Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x0002D83C00000847000100000000, Command ID: 1)

Error messages:
Invalid column name 'NUM'. (Source: MSSQLServer, Error number: 207)
Get help: http://help/207

The column exists on both primary and secondary databases.

Below is the message from SQL Log

Date 7/10/2009 4:32:46 PM
Log SQL Server (Current - 7/10/2009 4:32:00 PM)

Source spid52

Message
Replication-Replication Distribution Subsystem: agent xxxxxxxxVB01\SQL1-xxxxx-xxxxx_Publication-xxxxxxxVB02\SQL2-1 failed. Invalid column name 'NUM'.

I am not sure what is causing this error.

Any suggestions or inputs would help

Thanks

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-07-13 : 04:37:42

Has it been running fine before this?

If so, have the sizes of the column changed and if so, have you pushed out a new snapshot?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources