SQL Server Error Code – 22583 article ‘%s’ cannot be added or modified

In this blog post, you’ll learn more about the SQL Server Error Code 22583 and the error message description that is shown

SQL Server Error Code

22583

SQL Server Error Description for the Code :22583

Article ‘%s’ cannot be added or modified in publication ‘%s’. The replication of FILESTREAM columns is not supported for articles that have a ‘schema_option’ set to 0x20000000. This converts large object data types to data types that are supported on earlier versions of Microsoft SQL Server. Remove this ‘schema_option’ setting by using sp_addmergepublication or sp_changemergepublication, or partition the article vertically so that the FILESTREAM column is not replicated.

Leave Your Comment