• Andrew G (12/16/2013)


    Check that the TSR_ACCOUNT_VEHICLE table schema is the same between databases.

    If it is, drop the article from publisher, drop table on subscriber. Add article, snapshot, should work according to this: http://www.sqlservercentral.com/blogs/jeffrey_yao/2008/06/03/replication-error-quot-field-size-too-large-quot/

    Or you could just modify the table on the subscriber to match that of the publisher (minus any identity column setting usually).

    It seems strange that the schema would be different if it was initialised from a snapshot.