>Sergey,
>
>>How long takes

>>execute(@CMD)
>>

?
>
>From SQL_A only 2 seconds which is the same as when run from SQL_B. So if the insert is taking that freaking long let me check if there is some column incompatibility between the #temp and the result set....

Hi David,

Maybe SQL Profiler can give you a hint.