Cannot show requested dialog (SqlMgmt).
Applies to: Microsoft SQL Server 2005.
Microsoft SQL Server Management Studio (SSMS) showed the following error when
trying to access the Properties of a given database:
Cannot show requested dialog (SqlMgmt)
An exception occurred while executing
a Transact-SQL statement or batch.
Lock request time out period
exceeded. (Microsoft SQL Server, Error: 1222)
An index defragmentation process was running on some of the database tables
when SSMS threw the error.
After the defragmentation process finished, SMSS was functioning as usual.