September 5, 2013 at 6:45 am
Hi Experts,
What happens if i cancel a bulk insert operation for 1 Billions rows into a table in between?
is the effect same for queries using command BCP , BULK INSERT and INSERT INTO?
TIA
September 6, 2013 at 3:54 am
Can anyone please help?
September 6, 2013 at 1:07 pm
It rolls back, same as any other data modification when stopped part way through.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 7, 2013 at 1:31 am
Thanks a lot Gail.
September 9, 2013 at 7:01 am
The BCP utility has a batch parameter that allows you to specify the number of records to group in a transaction. If something happens during the BCP process, only the last batch will be rolled back. If this parameter is not used the entire set will be one batch.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy