Post reply

Switching between two partition tables

  • June 22, 2006 at 12:55 pm

    #168858

    ALTER

    TABLE dbo.employee SWITCH PARTITION

    $partition

    .HourRangePF1(762) TO [dbo.employeearchieve$partition.HourRangePF1(762)]

    Will this script work im trying to switch partition between the tables. im trying to switch the partition between employee table and employeearhieve table.

  • June 23, 2006 at 7:07 am

    #645520

     The syntax should be:

    ALTER TABLE dbo.employee SWITCH PARTITION $partition.HourRangePF1(762) TO [dbo].[employeearchieve] PARTITION $partition.HourRangePF1(762)]

    There are some basic requirements on the schema of the source and target table. Please check BOL for details.

  • June 23, 2006 at 7:38 am

    #645533

    Yeah actually I had over looked that yday and I fixed it. thanks peter.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply