If you insert a large amount of data, for example more than 1 MB, into SQL database in one single operation , the chance are that SQL Profiler is going to skip this operation, leave all fields blank, and mark as “Trace Skipped Records”. Don’t worry. The operation is still inserted into database, and only SQL Profiler skips the operation.
You might ask how to solve this problem. The easiest way to see records inserted is to decrease the size of data inserted. There are other ways, of course[2, 3, 4].
- SQL Insertion of Thousands Records Too Slow?