>>
>>If you're not running anything extra such as Reporting Services,
>
>I am running Reporting Services, what do I need to do differently?
>
>FWIW I changed my code to use another tableadapter and it worked fine, so it seems to be something wrong with this one.
I meant that SSRS usually sends lots of statements, so it may interfere with your trace.
If it's not broken, fix it until it is.
My Blog