Microsoft KB Archive/102417

FIX: Insert Into View Causes GP Fault

PSS ID Number: Q102417 Article last modified on 10-31-1994

4.20

OS/2

BUG# OS/2: 1729 (4.2)

= SYMPTOMS =

An insert into a view after dropping an underlying table may cause a general protection fault (GP fault). A typical scenario would be as follows:


 * 1) create table t1
 * 2) create view v1 referencing table t1
 * 3) drop table t1
 * 4) insert into v1

= WORKAROUND =

Make sure you recreate all underlying tables before an INSERT into a view.

= STATUS =

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2. This problem was corrected in SQL Server version 4.2aK11. For more information, contact your primary support provider.

Additional reference words: 4.20 gp-fault KBCategory: kbprg kberrmsg KBSubCategory: SSrvServer SSrvGPF

=
================================================================

Copyright Microsoft Corporation 1994.