BUG: Database Upgrade May Generate Error #159 (146018)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
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.
| Modification Type: | Minor | Last Reviewed: | 3/2/2005 |
|---|
| Keywords: | kbsetup KB146018 |
|---|
|