Microsoft KB Archive/146018

= BUG: Database Upgrade May Generate Error #159 =

Article ID: 146018

Article Last Modified on 3/2/2005

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.