• Well, without seeing the script, the table and being able to query the data, I can't say for sure, but ideally yes.

    Before you do so, make sure that there is no data that would fall on the 'other side' of the new partition boundary you're creating. You also want to run this at the time the table is quietest. I know it's probably never idle, but lowest query volume.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass