Re: UPDATE query gives Incorrect Syntax error

On Aug 26, 3:56 pm, Erland Sommarskog <esq...@xxxxxxxxxxxxx> wrote:

Interesting. Are there any triggers on the table?

If there is not, my suspicion that you are somehow mistaken about the
statement that causes the error. Using Profiler and including the events
Error:Exception and Error:UserMessage can be a good idea.

--
Erland Sommarskog, SQL Server MVP, esq...@xxxxxxxxxxxxx

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text -

- Show quoted text -

Hi Erland

No - no triggers on the table.
Indeed it was just a case of creating a new database, add a table and
add fields.
I suspect you may be right about the statement that is causing the
error message however the UPDATE query is the only statement I am
trying to run.
Is it possible that a previous query has somehow become trapped and is
being retried by SQL Server when I am trying to run my query?
I'll investigate the use of the Profiler to try and determine exactly
what is going on.
Can you point me to an online tutorial for the Profiler as the MSDN
wasn't that easy to follow?

Chris

.