BUG: Error 403 or 602 on Table Insert of UNION of Views

• Microsoft SQL Server, version 4.21a

SYMPTOMS

An INSERT into a table of a SELECT on a view/UNION/view may fail with either an error 403 or an error 602.

An INSERT into a table (temporary or permanent) of a UNION ALL of two or more views may fail with the error:

   Msg 403, Level 16, State 1:
   Invalid operator for datatype op: UNKNOWN TOKEN type: <datatype>

An INSERT into a table of a UNION of secondary views (a view on a view) may fail with the error:

   Msg 602, Level 21, State 3:
   Could not find row in Sysindexes for dbid '4', object
   '1932533918', index '0'. Run DBCC CHECKTABLE on Sysindexes.
   The SQL Server is terminating this process.

WORKAROUND

Break the UNION into individual INSERT statements. For example, you can rewrite the following query:

   insert into table
   select * from view1
   UNION ALL
   select * from view2

   insert into table
   select * from view1
   insert into table
   select * from view2

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.21a. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

This problem does not occur in SQL Server version 6.0.