We use a similar script and recently partitiond a database. Now I receive a syntaxerror on this statement:

ALTER INDEX [MUTA_PI3]

ON [prd_00rpd_hrm].[hrm].[MUTA]

REBUILD

WITH

(ONLINE = ON,

FILLFACTOR = 90,

MAXDOP = 0)

PARTITION = 2;

error: Msg 102, Level 15, State 1, Line 8

Incorrect syntax near 'PARTITION'.

I can't figure out what the correct syntax is. Leaving out the PARTITION statement works, leaving out the WITH statement works. I can't find an example combining the 2.

Help please?