EXEC usp_PartitionDatabase '<dbname>', '<right_or_left>', '<date_or_numeric>', '<interval>', '<set_max_value>'
For <interval> the options are:
If datetime key, interval may be: month, quarter, semester, year, between single quotes
If datetime key, set_max_value is a maximum date in dd-mm-yyyy format between single quotes
If numeric key, interval may be: hundreds, thousands, t_thousands (tens of thousand), h_thousands (hundreds of thousand), millions, between single quotes
If numeric key, set_max_value is a maximum number, between single quotes
Example with numeric key:
EXEC usp_PartitionDatabase 'database', 'left', 'numeric', 'h_thousands', '10000000'
Example with datetime key:
EXEC usp_PartitionDatabase 'database', 'right', 'date', 'quarter', '01-01-2011'
