>>:) I've run the profiler, but have no idea of what I'm looking at so I need to do some research into how to interpret it. Any pointers to a good description?
>
>For now I believe you can use default template. If you're not running anything extra such as Reporting Services, just before you run your problematic code start the trace and stop it right after. You should see the command at the bottom part of the profiler, grab it and try executing in SSMS.

Thanks, see my reply to Boris