Share via

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.

Comments

  • Anonymous
    May 10, 2014
    tank you . very good
  • Anonymous
    July 17, 2014
    Thanks, Detached a SQL 2005 database and attached to SQL2012. This was the problem. Easy fix as noted above.
    Got quite a few database I have to move, at least I know I have to do this on all of them.