01/12/2008

Issue:
When Migrating a DotNetNuke 2.1.2 Installation from SQL Server 2000 to SQL Server 2005 the Reporting may stop working in Form Master for DotNetNuke 2.1.2

Reason:
SQL Server 2005 handles The "FOR XML" Clauses differently than SQL Server 2000

Note:
Form Master for DotNetNuke 2.1.2 with SQL Server 2005 is an un-supported configuration.

Fix:
Follow these steps
1. BACKUP YOUR DATABASE!
2. Unzip the attached file below
3. Open FMDNN2_SQL2005_Fix.txt in notepad
4. Type Ctrl-A then Ctlr-C to copy the contents to the clipboard
5. In Host -> SQL Paste the text into the textbox
6. Click on Execute