Commit Massive INSERT every 100 rows

Hi, all!

I'm running an INSERT statement which is fed by an enormous Query to the SQL database. Something like this:

INSERT INTO table_name (column1, column2, ...)
SELECT * FROM another_table_name

This takes about 45 minutes to execute and throughs TEMPDB up into the sky (about 13 GB). Sometimes, the insert statement stops because of unsuficient disk space.

What I'd like to know is: Is there any database parameter or something, that forces an INSERT statement to insert + commit every 100 rows, for example?

Thnx & Regards
PauloStart Free Trial