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.
Thank you! I had forgotten, but a quick Google search brought me to your straight-forward answer.
ReplyDeleteYep. Tks much. Solved it for me too. Best, Raphael.
ReplyDelete