When upgrading MessageStats you get the following error during the Database Migration.
Attempting to Migrate Application Specific Database Objects
ERROR OCCURRED DURING DATABASE OBJECT MIGRATION WHILE EXECUTING THE FOLLOWING:
IF (SELECT CAST(LEFT(CAST(SERVERPROPERTY('ProductVersion') AS NVARCHAR(10)),
CHARINDEX('.',CAST(SERVERPROPERTY('ProductVersion') AS NVARCHAR(10)))-1) AS INT)) > 8
BEGIN
EXEC ('sp_configure ''show advanced options'', 1');
EXEC ('RECONFIGURE');
EXEC ('sp_configure ''Ole Automation Procedures'', 1');
EXEC ('RECONFIGURE');
END
THE ERROR DESCRIPTION IS:
The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration
The affinity I/O masks and affinity masks are set to conflicting values in the SQL Server CPU properties. If these configuration values do conflict, when you try to run the RECONFIGURE command, SQL will return this error.
Reset the affinity I/O masks and affinity masks back to their default values.
Open SQL Management Studio.
Right click on the SQL Server node and select properties.
Click the Processors page.
Check "Automatically Set" for both "affinity mask" and "I/O affinity mask"
