another partition function failed to create
Posted on 2007-09-28
I already created a partition function as below
CREATE PARTITION FUNCTION partfunc (int) AS
RANGE LEFT FOR VALUES (1000, 2000, 3000, 4000, 5000);
and its being used already and now I want to create another partition function wit use of data type (varchar)
CREATE PARTITION FUNCTION tvpartfunc (varchar) AS
RANGE LEFT FOR VALUES (100, 200,300)
but this statement above return me an error below
Msg 7708, Level 16, State 1, Line 1
Duplicate range boundary values are not allowed in partition function boundary values list. Partition boundary values at ordinal 1 and 2 are equal.
Is that means only one partition function can be created at database?