I've never used profiler but I'll try,

witch template I should use to perform the test you suggest?

then it look very hard to correlate the sp that make tempDB growing

Is there a shortcut to know how much space of tempdb is used by SP.

thank you also for the explanation of the error, the point

is that this code is a typical example of something write by

some one who don't really use it 😉

(It' full of small error)

thank you again,

Lorenzo