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.


  1. Thank you! I had forgotten, but a quick Google search brought me to your straight-forward answer.

  2. Yep. Tks much. Solved it for me too. Best, Raphael.