Answer
PROBLEM
Unable to attach a Microsoft SQL Server 2000 database...\Store\DebugLogs\ManagementProviders.log shows the error:
"error ","ManagementProviders","Error: (MSSql) UpdateSchema. Rolling back
;message: Invalid object name 'sys.columns'.
or
;message: Line 12: Incorrect syntax near '('.
or
;message: Incorrect syntax near '@userHash'.
ENVIRONMENT
- GFI MailArchiver 2012 or newer
- Microsoft SQL Server 2000
SOLUTION
- Upgrade to a supported Microsoft SQL Server version
- Move databases to a supported Microsoft SQL Server version
Please refer to Microsoft on details how to view or change the compatibility level: http://msdn.microsoft.com/en-gb/library/bb933794.aspx