SQL Server Error Code – 22585 the schema option to script out the file

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

SQL Server Error Code

22585

SQL Server Error Description for the Code :22585

The schema option to script out the FILESTREAM attribute on varbinary(max) columns has been enabled for article ‘%s’. Enabling this option after the article is created can cause replication to fail when the data in a FILESTREAM column exceeds 2GB and there is a conflict during replication. If you want FILESTREAM data to be replicated, drop and re-create the article, and specify the appropriate schema option when you re-create the article.