Replication: Watch out for STREAM_BLOB_COLUMNS when setting up replication on your SQL 2008 + server

When setting up merge replication on your SQL 2008 + server, please be careful with the parameter STREAM_BLOB_COLUMN. By default, this option is set to FALSE, as explained here in BOL:  [ @stream_blob_columns= ] ‘stream_blob_columns’Specifies that a data stream optimization be used when replicating binary large object columns. stream_blob_columns is nvarchar(5), with a default of…

0

Replication: If sql_variant column includes a value with new datetime type, the value is replicated as base type nvarchar even if schema option 0x200000000 is not set

Problem: If sql_variant column includes a value with new datetime type, the value is replicated as base type nvarchar even if schema option 0x200000000 is not set during the application of the SNAPSHOT (only). After the snapshot has been applied, if you execute the command to verify the property of the sql_variant column: SELECT SQL_VARIANT_PROPERTY(column_name,‘BaseType’),…

0