'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.
