I had the same problem using SQL 2005 with a linked MySQL database.

After a few tests it was definately caused by trying to update a column in the MYSQL table...

Hi SQL Bill,

I think you are getting confused.

If you check out the syntax for an openquery, it is as used. You don't do "two queries" as you have suggested. The...

Well, for my two penneth worth I thought the article was very useful as well as all the subsequent replies.

However, Ed stated that the correct "where" clause should have been :

WHERE datepart(m,...