Scenario, the database was created on a SQL Server 2012, and was migrated to SQL 2019, when I was setting up replication I received the following error:
Message
Replication-Replication Snapshot Subsystem: agent My_pub-3 failed. The replication agent had encountered an exception.
Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException
Exception Message: The option "INLINE=ON" is not valid for this function.
I am not a Database Administrator and the easy solution that I found was drop and recreate the function, after that the replication works fine.
On SQL Management Studio:
Nenhum comentário:
Postar um comentário