SQL Server Error Msg 20737 – Warning: To allow replication of FILESTREAM data to perform optimally and reduce memory utilization, the ‘stream_blob_columns’ property has been set to ‘true’.  To force FILESTREAM table articles to not use blob streaming, use sp_changemergearticle to set ‘stream_blob_columns’ to ‘false’.

In this blog post, let’s learn about the error message “20737 – Warning: To allow replication of FILESTREAM data to perform optimally and reduce memory utilization, the ‘stream_blob_columns’ property has been set to ‘true’.  To force FILESTREAM table articles to not use blob streaming, use sp_changemergearticle to set ‘stream_blob_columns’ to ‘false’.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

20737 – Warning: To allow replication of FILESTREAM data to perform optimally and reduce memory utilization, the ‘stream_blob_columns’ property has been set to ‘true’.  To force FILESTREAM table articles to not use blob streaming, use sp_changemergearticle to set ‘stream_blob_columns’ to ‘false’.

Reason for the Error

To be update soon…

Solution

To be update soon…