Partition Instance

[NoCalAdmin]

I have been trying to partition a table on my local instance which is a SQL 2005 Developer edition SP2 and was able to create the partitions and work on them successfully. While I am trying to create the same on the instance of [database name]on [servername], I was not able to and it gives out an error message of
‘Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning.’

the server is running SQL Server 9.00.1399.06 - RTM (Standard Edition)

I do not beleive we need the Enterprise version, but rather a service pack update.

Can anyone confirm or deny this? And what update is advised?

Tom

 

[mrdenny]

Table partitioning requires Enterprise Edition or higher. It isn't available on standard edition or lower.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Site

 

[NoCalAdmin]

MrDenny-
Will the partitioning be available in version SQL 2008 Standard?

Thanks in advance

Tom

 

[mrdenny]

No, it is still (and probably will be for several releases) an Enterprise Edition feature. If you have enough data that you need to partition the table, and the hardware to make table partitioning work well then you probably need Enterprise Edition for some of the other features, and you've probably got the budget for Enterprise Edition.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Site