Create replication fails on database which is migrated from SQL Server 2005 with error
Error:
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
——————————
Invalid column name ‘originator_id’. (Microsoft SQL Server, Error: 207)
Resolution:
1. Add originator_id column to syspublications table in publication db. Run below query in your publication DB.
ALTER TABLE dbo.syspublications ADD [originator_id] [int] NULL;
2. Add a column originator_id into the view dbo.syspublications inside distribution database
3. Add a originator_id column into IHpublications table in distribution database