When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to change index properties, they should follow the next steps:
1. In Object Explorer, right-click the table they want to open and click Design (Modify in SP1 or earlier).
2. From the Table Designer menu, click Indexes/Keys.
3. Select the index from the Selected Primary/Unique Key or Index list.
4. Change properties in the grid.
Their changes are saved to the database when they save the table.