SQL Server Management Studio won’t let me add an index to a table

Solution: Close your table designers and database diagrams and try again. If that doesn’t help, close all windows in Management Studio.

Cause: The “New Index” option gets disabled when the table is schema-locked by the designer window.