Knowledge Base

BUG: Database Upgrade May Generate Error #159

Article ID: 146018

Article Last Modified on 3/2/2005

Microsoft SQL Server 6.0 Standard Edition
Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q146018

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 versions 6.0 and 6.5. 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 KB146018