Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    India
    Posts
    15

    Unanswered: set NO_BROWSETABLE

    Hi

    In the profiler I can see SET NO_BROWSETABLE ON and OFF commands getting fired. what is the significance of these..

    Thx

  2. #2
    Join Date
    Jan 2004
    Location
    Romania
    Posts
    1
    Quote from Q178366:

    "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"

    For more informations about Browse Mode see:
    http://msdn.microsoft.com/library/en...pdc02_4tb9.asp

    Razvan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •