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

Article ID	1053	Posted Date	3/20/2006
Product(s)	Ultimate Survey - Enterprise .NET Edition with Dev Kit	Updated Date	3/20/2006

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.