Microsoft KB Archive/102417

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.