another partition function failed to create

Posted on 2007-09-28
Last Modified: 2008-01-09
I already created a partition function as below

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)

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?
Question by:motioneye
    LVL 142

    Accepted Solution

    any better with this:

    CREATE PARTITION FUNCTION tvpartfunc (varchar) AS
    RANGE LEFT FOR VALUES ('100', '200','300')
    LVL 16

    Assisted Solution

    You will need to pass varchar ie strings if thats what your going to declare them as.

    Author Comment

    Try with the statement below

    CREATE PARTITION FUNCTION tvpartfunc (varchar) AS
    RANGE LEFT FOR VALUES ('100', '200','300')

    and getting error below

    Msg 7720, Level 16, State 1, Line 1
    Data truncated when converting range values to the partition function parameter type. The range value at ordinal 1 requires data truncation.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now