Adding more ranges to the partition function.

• born4learn

  Grasshopper

  Points: 16

  More actions

  December 16, 2008 at 9:24 am

  #129324

  Hi ,

  We have partitions for below table XXXX from last 2 years in order to add 2 more years I thought I can do alter partition function but it is giving me syntax error. Can some tell me this is the right way to do it ?

  ALTER PARTITION FUNCTION [fun_XXXX]()

  { SPLIT RANGE (

  '2009-01-01T00:00:00',

  N'2009-02-01T00:00:00',

  N'2009-03-01T00:00:00',

  N'2009-04-01T00:00:00',

  N'2009-05-01T00:00:00',

  N'2009-06-01T00:00:00',

  N'2009-07-01T00:00:00',

  N'2009-08-01T00:00:00',

  N'2009-09-01T00:00:00',

  N'2009-10-01T00:00:00',

  N'2009-11-01T00:00:00',

  N'2009-12-01T00:00:00',

  )

  };

• Stad

  SSC Eights!

  Points: 964

  More actions

  September 15, 2011 at 10:55 am

  #1382153

  born4learn,

  I am at right same situtation as yours.

  Can you please post the solution that how you were able increase partition range from 2 years to 4 years.

  Thanks in advance!

  Stad

• julie.rasnick

  SSC Rookie

  Points: 31

  More actions

  September 16, 2011 at 7:12 am

  #1382527

  You need to issue one split statement per new range.