Hello,
I'm trying to delete an existing varchar(10) column called "abc1" o in a
table on a SQL 2000 database and I'm getting the following error message in
Enterprise Manager.:

'web_cartOrders' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
syntax near 'abc1'.


I tried to delete it from SQL Analyzer directly from the server's console,
but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'abc1'."

I tried to rename, change data type and size of the data type of the column,
but still could not delete it.

Any thoughts?
Thanks

might be worth running Profiler to capture the SQL that is getting issued /
generated by Enterprise Manager just to try and see whats going on

Andy.
"Vi" <Vi@discussions.microsoft.com> wrote in message
news:B221D62F-4C50-4DEB-96F0-766AE8B7D8EF@microsoft.com...
> Hello,
> I'm trying to delete an existing varchar(10) column called "abc1" o in a
> table on a SQL 2000 database and I'm getting the following error message
in
> Enterprise Manager.:
>
> 'web_cartOrders' table
> - Unable to modify table.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:
Incorrect
> syntax near 'abc1'.
>
>
> I tried to delete it from SQL Analyzer directly from the server's console,
> but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line
1
> Line 1: Incorrect syntax near 'abc1'."
>
> I tried to rename, change data type and size of the data type of the
column,
> but still could not delete it.
>
> Any thoughts?
> Thanks

Check your database compatibility level. I know some people
have hit the error when it's set to 64. You can execute
sp_dbcmptlevel to check it.

-Sue

On Tue, 10 Aug 2004 15:25:04 -0700, "Vi"
<Vi@discussions.microsoft.com> wrote:

>Hello,
>I'm trying to delete an existing varchar(10) column called "abc1" o in a
>table on a SQL 2000 database and I'm getting the following error message in
>Enterprise Manager.:
>
>'web_cartOrders' table
>- Unable to modify table.
>ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
>syntax near 'abc1'.
>
>
>I tried to delete it from SQL Analyzer directly from the server's console,
>but I'm getting a similar error: "Server: Msg 170, Level 15, State 1, Line 1
>Line 1: Incorrect syntax near 'abc1'."
>
>I tried to rename, change data type and size of the data type of the column,
>but still could not delete it.
>
>Any thoughts?
>Thanks