SQL Server Performance Forum – Threads Archive
BCP RollbackDear All, Can anyone tell me why the rollback doesn’t happen if a BCP command fails?
BCP is a non-logged operation. So SQL Server can’t roll it back because it doesn’t have the necessary log-records to be able to do that. It is sometimes a good idea to bcp into a worktable first, then verify it’s worked correctly, and then from there move the data into its proper place (if data volumes are manageable).