Can't create partitioned table in Developer Edition?

I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
fails saying that partitioned tables may only be created in Enterprise
Edition. What gives, DE is supposed to have all the capabilities of EE?
Scott
On Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
> fails saying that partitioned tables may only be created in Enterprise
> Edition. What gives, DE is supposed to have all the capabilities of EE?
> Scott
I have no problem on a developer edition
What does this return?
select serverproperty('Edition')
I have no problem running the following on a developer edition
CREATE PARTITION FUNCTION pf_Range (int)
AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
GO
CREATE TABLE TestPartition (id int not null)
INSERT TestPartition VALUES(1)
INSERT TestPartition VALUES(2)
INSERT TestPartition VALUES(3)
INSERT TestPartition VALUES(10)
INSERT TestPartition VALUES(11)
INSERT TestPartition VALUES(17)
INSERT TestPartition VALUES(18)
INSERT TestPartition VALUES(19)
INSERT TestPartition VALUES(21)
INSERT TestPartition VALUES(25)
INSERT TestPartition VALUES(22)
INSERT TestPartition VALUES(23)
INSERT TestPartition VALUES(0)
INSERT TestPartition VALUES(5)
GO
CREATE PARTITION SCHEME ps_Range
AS PARTITION pf_Range
ALL TO ([PRIMARY])
GO
CREATE CLUSTERED INDEX IX_TestPartition_ID
ON TestPartition(ID) ON ps_Range(ID)
SELECT $PARTITION.pf_Range(ID) AS Partition,*
FROM TestPartition
ORDER BY Partition
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||That's interesting, it returns 'Standard Edition'. I thought I downloaded DE
with my MDSN subscription. I'll go back through the process to see where I
went wrong.
Thanks.
"SQL Menace" wrote:

> On Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I have no problem on a developer edition
> What does this return?
> select serverproperty('Edition')
> I have no problem running the following on a developer edition
> CREATE PARTITION FUNCTION pf_Range (int)
> AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
> GO
>
> CREATE TABLE TestPartition (id int not null)
> INSERT TestPartition VALUES(1)
> INSERT TestPartition VALUES(2)
> INSERT TestPartition VALUES(3)
> INSERT TestPartition VALUES(10)
> INSERT TestPartition VALUES(11)
> INSERT TestPartition VALUES(17)
> INSERT TestPartition VALUES(18)
> INSERT TestPartition VALUES(19)
> INSERT TestPartition VALUES(21)
> INSERT TestPartition VALUES(25)
> INSERT TestPartition VALUES(22)
> INSERT TestPartition VALUES(23)
> INSERT TestPartition VALUES(0)
> INSERT TestPartition VALUES(5)
> GO
>
> CREATE PARTITION SCHEME ps_Range
> AS PARTITION pf_Range
> ALL TO ([PRIMARY])
> GO
>
> CREATE CLUSTERED INDEX IX_TestPartition_ID
> ON TestPartition(ID) ON ps_Range(ID)
>
> SELECT $PARTITION.pf_Range(ID) AS Partition,*
> FROM TestPartition
> ORDER BY Partition
>
> Denis the SQL Menace
> http://sqlservercode.blogspot.com/
>