I've got an application that takes data from one table, do certain processes with the data and put it on other tables.
The problem is the data space in tempdb become full at record number 280. I did some test and I did identify that the inserts are the problem, without them the process runs normally with 5000 records.
I'm doing about 4 selects, calling 4 Stored Procedures to verfiy data and i'm doing around 8 inserts per record.
I'll apreciate some help.