Innovative Survey & Feedback Solutions

Phone Contact

'Ambiguous column name 'AnalysisName'' message when clicking Reports in Ultimate Survey Enterprise Edition

Article ID: 1053 Posted Date: 3/20/2006 8:58:17 AM
Products: Ultimate Survey - Enterprise .NET Edition
Ultimate Survey - Enterprise .NET Edition with Dev Kit		 Updated Date: 3/20/2006 8:58:17 AM

Symptom:

If you are using SQL Server 2005 you may receive an error message when clicking on Reports that says "Ambiguous column name 'AnalysisName'".

Resolution:

In the properties window for your Ultimate Survey database, on the Options page, there is a setting that says Compatibility Level. By default it is

set to SQL Server 2005 (90). If you switch it to SQL Server 2000 (80), the error will stop occurring.