FIX: SELECT Into Variable with NO_BROWSETABLE Fails

MORE INFORMATION

This problem does not occur on builds of SQL Server earlier than 6.50.258 (Service Pack 3). This problem has been tested and reproduced on SQL Server build 6.50.281 (Service Pack 4).

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.

The following script demonstrates the problem:

   set nocount on
   go
   use pubs
   go
   DROP TABLE test_unknown_token1
   go
   CREATE TABLE test_unknown_token1 (

      col1 char(1),
      timestamp timestamp
   )
   go

   insert test_unknown_token1 (col1) values ('1')
   go

   set no_browsetable on
   go
   declare @ochrStatus char(1)

   SELECT @ochrStatus = col1
   FROM dbo.test_unknown_token1
   WHERE col1='1'