03-28-2013 08:31 AM
I want to update the longnotes field in the History table, and many of the notes are quite long. I wanted to issue an Execute SQL command, since there are some remotes that also need this update. Therefore, I believe I need to cast the field as varchar(max) within the replace function. I know that varchar(max) is not compatible with the SQL 2000 compatibility level, and have updated the level on the database to 90 (or 100). But still result in a "cannot parse SQL" error. Does anyone know of the SalesLogix OLEDB provider is limited to the compatibility level of 80 (SQL 2000)? I may have to take a different approach.