Viewing 2 posts - 1 through 2 (of 2 total)
Not really wrong , I just found that the partitions end up not as desired
Current order
parition_number ------- FG_Name -- Left_range -- right_range
6 ...
August 30, 2012 at 12:13 pm
#1532053
Voila
ALTER PARTITION SCHEME PS_BY_YEARMONTH_ Next Used 2013_JAN_MAR;
ALTER PARTITION FUNCTION PF_FTD_YEARMONTH() SPLIT RANGE (201301);
August 30, 2012 at 9:01 am
#1531957