SYMPTOM:
While configuring Strategy Enterprise Manager 9.x using SQL Server 2005 Standard edition as the Enterprise Manager warehouse, the following error occurs during the configuration stage:
Sample Code/Error
Strategy Project Mover Wizard - Transferring Warehouse tables
Error executing query: Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning. SQL: CREATE PARTITION FUNCTION MSTR_EM_DAY_ID(DATETIME) AS RANGE RIGHT FOR VALUES (....)
CAUSE:
The incorrect SQL script (em_sql_2005-2008.sql) was selected during the configuration wizard:
The script em_sql_2005-2008.sql should only be used for those Microsoft SQL Server editions/versions that support partitioning.
ACTION:
Use the SQL script "em_sql.sql". This script file should be used for Microsoft SQL Server editions/versions, including 2005/2008, that do not support partitioning.
