Share via

SQL Server Partition Wizard Not seeing in SQL Server 2012

Jinal Contractor 121 Reputation points
2020-10-03T18:28:40.55+00:00

Hello,
I would like to do Partition in some tables in SQL Server Database 2012 but I can not see option for Storage when I right click on the table.
I've SQL server 2012 version. Can you please help me to get the Storage option?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,018 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 112.7K Reputation points MVP
    2020-10-03T19:01:58.807+00:00

    What exactly does "SELECT @@version" report? My guess is that you have Standard Edition where partitioning is not supported with SQL 2012.

    0 comments
  2. CathyJi-MSFT 22,306 Reputation points Microsoft Vendor
    2020-10-05T03:20:16.207+00:00

    Hi @Jinal Contractor ,

    What is your SQL server 2012 edition? Partitions available only in Enterprise edition of SQL Server 2012. Please refer to MS document Features Supported by the Editions of SQL Server 2012.

    29919-screenshot-2020-10-05-111914.jpg

    Best regards,
    Cathy Ji

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.