¿Cómo puedo solucionar el "SELECT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. "

Question

Se ha configurado el SQL Replication y cuando el sistema intenta entregar al SQL Subscriber el snapshot inicial, se obtiene el error debajo y el proceso se detiene: SELECT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. (Source: MSSQLServer, Error number: 1934)