Good idea, thanks Lowell.

Hi Lowell,

Thanks for your response, but I don't think the OUTPUT clause will help me. I should have posted a full example showing the problem the first time:

CREATE TABLE...

Thanks for the reply. I can already see the execution plan, my question is why doesn't it show anything useful. All it shows is that SQL Server is...