Snapshot agent fails with Error: 241, Severity: 16, State: 1 (Conversion failed when converting date and/or time from character string)

ISSUE Let’s say you are monitoring Replication Agent status and noticed that the Snapshot Agent has failed with the following error while generating a snapshot, particularly during creation of BCP files. Error: 241, Severity: 16, State: 1 Conversion failed when converting date and/or time from character string. To further investigate the above error and to…

1