Create failed for Index not supported on the target server version. No Panic

  • Article

ColumnStore Index the New Cool non-clustered index feature in SQL2012 with
significant boost in performance while been used. I tried to create it on my
newly restored Database but I received this Error

“Create failed for Index Either the object or one of its properties is not
supported on the target server version.
(Microsoft.SqlServer.Smo)”

oh…!!! this is not cool, well not so fast…!!! it’s related to your
compatibility level of your database so this could be fixed very easy.

1. Choose your Database then Click Properties

2. choose Options tab and change the compatability level to
SQL Server 2012 (110). then OK

now try again to create your index and … Yes I can.