This post originated from an RSS feed registered with .NET Buzz by douglas reilly. Original Post: SQL Syntax Error or Access Violation (42000) Feed Title: Doug Reilly's Weblog Feed URL: http://www.asp.net/err404.htm?aspxerrorpath=/dreilly/rss.aspx Feed Description: ASP.NET and More... Latest .NET Buzz Posts Latest .NET Buzz Posts by douglas reilly Latest Posts From Doug Reilly's Weblog

I spent about an hour that I can never get back today tracking down a problem with a stored procedure I was writing.  The SP was a simple SAVE SP, with a test for existance of a row, and then an INSERT or UPDATE.  The error message (in all the tools I have) was an unhelpful SQL Syntax Error or Access Violation (Error 42000).

In the end, the error was not the screwy column and table names (some with spaces and very long).  I had used curly braces rather than parentheses in the INSERT statement. This slight difference resulted in this error message.  Sigh.