yes that right we are getting complaints of timeouts. The stored procedure doing these inserts contains most of the longest running queries.

I was just asking that question

if it was more than 1 statement I wouldn't expect to see it multiple times in profiler?

to make sure I was not missing anything - I'm sorry if it was interpreted the wrong way.

This stored procedure does get called repeatedly. But I am guessing you are wondering if there a content issue. The thing is I ran a blocked process report in profiler (4 second threshold) for a extended period of time (at least a day) and when that procedure ran slow no blocked process report occurred. I did block a process in a dummy database on the db instance to make sure it was working ok.

Thanks!