Microsoft KB Archive/133089

{|
 * width="100%"|

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

 * }

Q133089

-

The information in this article applies to:


 * Microsoft SQL Server version 4.2x

-

BUG# NT: 9377 (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:

A message will be generated for many, but not all, datatypes used in the column definitions.

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.

NOTE: The dbid and object vary from case to case.

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

to look like:

  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. This problem does not occur in SQL Server version 6.0.

Additional query words: Windows NT

Keywords : kbother

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2