Wrong SQLSTATE for Native Error 2727
- From: "Aleksey Dmitriyev" <AlekseyDmitriyev@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 14:39:03 -0700
I get SQLSTATE 42S21 with native code 2727 when executing this query:
alter index index_junk on testauto rebuild
According to ODBC documentation the SQLSTATE should be 42S12 "Index not
found", not 42S21 "Column already exists". Is it a bug?
--
-- Aleksey Dmitriyev
.
- Follow-Ups:
- Re: Wrong SQLSTATE for Native Error 2727
- From: Bei Zhu [MSFT]
- Re: Wrong SQLSTATE for Native Error 2727
- Prev by Date: Does UPDATE BLOB Destroy the Cursor in SQL Server 2000?
- Next by Date: sql lost conection
- Previous by thread: Does UPDATE BLOB Destroy the Cursor in SQL Server 2000?
- Next by thread: Re: Wrong SQLSTATE for Native Error 2727
- Index(es):
Loading