May 10, 2002 at 1:22 am
Hi
In the profiler I have observed
SET NO_BROWSETABLE ON and OFF statements, what is the significance of these..
Thx
May 10, 2002 at 5:43 am
Straight from the horse mouth so to speak
quote:
SET NO_BROWSETABLE ON is an undocumented option performed for Remote Data Service (RDS) ActiveX Data Connector (ADC) connections to SQL Server. Enabling this option makes every SELECT statement act as though FOR BROWSE had been appended to the statement, but bypasses the temporary table that FOR BROWSE normally pipes the results through. The net effect is to add keys and timestamps to the query as hidden output columns so the client can update specific rows (updateable cursors) without separate trips to the server to pick up the meta-data and munging the query to get the appropriate columns.
This reference was found at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q178366 at should not in way have changed.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply