BUG: Database Upgrade May Generate Error #159

ID: Q146018

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG# NT: 11599 (6.00)

SYMPTOMS

The Check Upgrade (Chkupg.exe) utilty reports are error free, but during the database upgrade, error #156 is generated:

Msg 156, Level 15, State 1
Incorrect syntax near the keyword '%s'....

CAUSE

Check Upgrade ignores keyword conflicts if the keyword is used as a column heading.


   create procedure ABC
   as
     select CLOSE = "Test data"
   go

WORKAROUND

You can use quoted identifier syntax, correct the conflicts, or remove the keyword conflict.

STATUS

Microsoft has confirmed this to be a problem in Check Upgrade for SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: utility upgrade inst

Keywords : kbsetup kbtool SSrvInst kbbug6.00
Version : 6.0
Platform : WINDOWS
Issue type :