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

The information in this article applies to:

- Microsoft SQL Server version 4.2 for 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.