Thought I will share this – If you see a doQuery error while executing a SQL in a windows dialog and not on the typical Aprimo Error page, then you might want to check SQL Server’s compatibility level is set to SQL Server 2005. A sample of the error is below. This is with Aprimo 8.0.x.

To overcome the issue you want to ensure the SQL Server compatibility level is set to 2005 as below:

Thank you for your comments. Comments are moderated before they are published.