>>Martina
>>
>>Thank you.
>>
>>My question concerns the behavior in .NET.
>>The query runs slowly when i used command type Text, but when I make it a stored procedure, it flies.
>>In both cases I'm using the .NET connection.
>>
>Using Martina's suggestion what happens if you add SET ARITHABORT ON; as a first line in the commandtext ?
>
>If that doesn't work, you can add OPTION (RECOMPILE) at the very end of your query.
Thank you, Naomi.
Since the problem was fixed by using a stored procedure, I won't be going back to t his code.