Microsoft SQL Server: Cannot specify a value of 1, 2, or 3 for the parameter @partition_options because publication “%s” has a compatibility level lower than 90RTM. Use the stored procedure sp_changemergepublication to set publication_compatibility_level to 90RTM.

Microsoft SQL Server database ranks third in the relational database, second only to Oracle and MySQL database. when using it, it is inevitable to encounter various problems and warnnings. You may be dba or a developer, I hope this content can help you solve SQL Server error number 20681.

Error number: 20681

Severity level: 10

Event logged: Cannot specify a value of 1, 2, or 3 for the parameter @partition_options because publication “%s” has a compatibility level lower than 90RTM. Use the stored procedure sp_changemergepublication to set publication_compatibility_level to 90RTM.