You can eradicate SQL database consistency error go to replication folder of the object explorer and right click on it then select Launch Replication monitor. Then Launch Repl Monitor->My Publisher->NCFM and make a right click on it the n again select agent profile.When the Agent Profiles window is displayed, make sure the "Distribution Agents" page is selected. Then in the Agent profiles section, click and select the "Default for New" checkbox for "Continue on data consistency errors". You can click on the ellipsis button next to this profile, to view its parameters. The properties dialog box will open, and if you scroll down a bit, you will see the -SkipErrors Parameter, as highlighted below:Finally, click , and then to set the new default profile for the Distribution Agent.:-)