Local Professional IT Support For Your Business

We have been looking at all the websites we host recently, to update them and move to 64 bit server and coldfusion 9. Some of the older websites with low database requirements have been happily running on MS Access, so we are taking this opportunity to move to SQL server 2008.

Mostly this conversion runs smoothly, howerever we are creating a check-list of common pitfalls which may be of use to others.

One thing to look out for is the use of double quotes in the SQL call. This brings up the error mesage [SQLServer] Invalid column name '0', even when the actual offending double quote is round a data value ("0").