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/102416

From BetaArchive Wiki

FIX: Update Trigger Fails After Upgrading to 4.20K8

PSS ID Number: Q102416 Article last modified on 08-16-1995

4.20

OS/2

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

BUG# OS/2: 1727 (4.2)

SYMPTOMS

After upgrading to SQL Server version 4.20k8, an update trigger may fail with the following type of message:

Invalid column name ’‘. (Msg 207, Level 16, State 3). Invalid column name’‘. (Msg 207, Level 16, State 3). Invalid column name’’. (Msg 207, Level 16, State 3).

The column names contain indecipherable characters. This can also happen if a dump made on a server running a version earlier than 4.20k8 is loaded into a server running 4.20k8.

WORKAROUND

Drop and recreate the UPDATE trigger to avoid this problem.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.20K8 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 4.2k8 update trigger 207 KBCategory: kbsetup KBSubcategory: SSrvServer

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

Copyright Microsoft Corporation 1995.