Posted by Bob Barrows [MVP] on 08/29/07 15:02

raymond_b_jimenez@yahoo.com wrote:
> I've noticed in my .NET application (with ADO) that whenever a query
> is done to SQL Server, a query executing
> SET NO_BROWSETABLE ON
> is done before.
> This has an huge impact on performance, as the round-trip to the
> server takes the same time as the correct query. I believe that if
> "SET NO_BROWSETABLE ON" wasn't executed, performance would almost
> double and network traffic would be reduced.
> I've tried to find a reasonable answer on the net for this, but
> haven't managed. Has someone noticed this and knows how to correct it?
>
This may help:
http://www.vsj.co.uk/dotnet/display.asp?id=249
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Back to original message]