Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stewart Campbell How many partitions? RE: How many partitions?

  • August 12, 2010 at 11:59 am

    #1206250

    malleswarareddy_m (8/11/2010)

    Hi ,

    Is it working for sqls server 2005 or 2008?

    It's introduced in 2005 version, but partition is supported only in Enterprise edition. On other editions you will get error.

    Msg 7736, Level 16, State 1, Line 2

    Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning.

    SQL DBA.