How to view properties when trying to view the same index details in SQL Server Management Studio ?

Question:  

I’m able to add and edit Indexes using SQL Server Management Studio (SSMS) successfully, but unable to view properties when trying to view the same index details in SSMS. How to resolve this problem? 
 
Answer:

The user can view database.table.index properties using SQL Server Management Studio without any issue if that user has the privilege to perform such a task. But it is not possible to view an index’s properties if the database designer or table designed is opened at the same time. 

The reason behind this behaviour is that both the database and table designers use the state of tables including index properties to match the internal model of database engine. Reconciling the state on the server to the state in the model can “undo” any change made outside the designer environment.  For example, if you open the table designer in one instance of Management Studio and make a change (say, add a column) and at the same time change an index on that table using another instance of Management Studio, when the user saves the changes in the table designer, it will recreate the index with its previous definition (with a warning) because the old index is what the table designer loaded into its internal model when it launched.




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |