• Article

Manage Partition Wizard (Select Output Option Page)

Use this page to specify how you want to complete the modifications to your partitions.

Generate Script

When the wizard finishes, it creates a script in Query Editor to modify partitions in the table. Select Generate Script if you want to review the script, and then execute the script manually.

  • Script to file
    Generate the script to a .sql file. Specify either Unicode or ANSI text. To specify a name and location for the file, click Browse.

  • Script to Clipboard
    Save the script to the Clipboard.

  • Script to new query window
    Generate the script to a Query Editor window. If no editor window is open, a new editor window opens as the target for the script.

Run Immediately

  • Run immediately
    Have the wizard finish modifications to the partitions when you click Next or Finish.

Create Job

Select to modify the table partitions at a scheduled date and time.

  • Create job
    Schedule a job to modify partitions, and then click Schedule Job.

  • Schedule Job
    Open the New Job Schedule dialog box, where you can select, change, or view the properties of the scheduled job.