Microsoft KB Archive/102417

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:13, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q102417 to Microsoft KB Archive/102417 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

FIX: Insert Into View Causes GP Fault

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



The information in this article applies to:
- Microsoft SQL Server version 4.2 for OS/2

BUG# OS/2: 1729 (4.2)


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


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


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.