How many inserts can you have in a sql transaction.

Posted by Mav on Stack Overflow See other posts from Stack Overflow or by Mav
Published on 2010-05-28T00:19:24Z Indexed on 2010/05/28 0:21 UTC
Read the original article Hit count: 473

Filed under:

I have a task to do that will require me using a transaction to ensure that many inserts will be completed or the entire update rolled back.

I am concerned about the amount of data that needs to be inserted in this transaction and whether this will have a negative affect on the server.

We are looking at about 10,000 records in table1 and 60,0000 records into table2.

Is this safe to do in a single transaction?

© Stack Overflow or respective owner

Related posts about sql-server-2005