Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/102417

From BetaArchive Wiki

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.