Ike Ellis's thoughts on data, SQL Server, and software development.
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.