Share via

  • Article

Create Partition Wizard (Select Output Option Page)

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

Generate Script

When the wizard finishes, it creates a script to partition 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 partition the table when you click Next or Finish.

Create Job

Select to partition the table in the future at a scheduled date and time.

  • Create job
    Schedule a job to partition the table, 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.