sexta-feira, março 26, 2021

SQL Replication: The option "INLINE=ON" is not valid for this function - SQL Server 2019

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: