• ALTER TABLE [INVOICE]

    DROP CONSTRAINT [INVOICE_PK] WITH (MOVE TO SECONDERYDATA)

    After the move, we now recreate the PK Constraint:

    ALTER TABLE [INVOICE]

    ADD CONSTRAINT [INVOICE_PK] PRIMARY KEY CLUSTERED

    ( [column name] ASC

    )WITH (IGNORE_DUP_KEY = OFF) ON [SECONDERYDATA]

    You're specifying the FG name twice. You just need to do this

    ALTER TABLE [INVOICE] DROP CONSTRAINT [INVOICE_PK]

    ALTER TABLE [INVOICE] ADD CONSTRAINT [INVOICE_PK]

    PRIMARY KEY CLUSTERED

    (

    [column name] ASC

    )

    WITH (options)

    ON [newfilegroup][/CODE]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉