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',
)
};