Ike's thoughts on Power BI, SSRS, SSAS, DAX, T-SQL, and all things data and Microsoft.
Monday, May 18, 2009
New Index grayed out in SQL Server Management Studio
In SQL Server Management Studio, if you right-click on the indexes and you see new index grayed out, it is because the table is schema-locked in another window. Close the design view of the table and new index should now be black and usable.