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.
tank you . very good
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.