So I have MSSQL Version 8 (I think that's 2003). This database is used with an old .NET application that I'm currently rewriting in PHP. Most of that is irrelevant, however.

I use one user to do all the work against the database. I can SELECT data from any table without problems. I can run UPDATE and INSERT statements against some of the tables. But there are a few tables where I cannot run UPDATE or INSERT statements from my application. I always get this error:

Incorrect syntax near the keyword 'and'.

Even when I don't have an "and" in my WHERE clause!? I can run the query directly in the database from Enterprise Manager without any issues, but I get the above when running from my application on those specific tables. I don't see any obvious differences between the tables that would cause this problem.

Can anyone shed any light on this issue?