SET NO_BROWSETABLE ON ?

Aug 29, 2007

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?

rj

View 7 Replies


ADVERTISEMENT

NO_BROWSETABLE - What The Heck Is That?

Jun 17, 2004

Hi guys, does enybody know what does it do exactly?

SET NO_BROWSETABLE ON/OF?

Thanks much.
Dim

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved