I try to open the database properties window using SSMS but it fails with a lock request time-out. Other databases on the same server work normaly.
I have counted the number of locks using the sys.dm_tran_locks; dm-view and it returned 2,741,636, there are no deadlocks or any other problems in that database.
I ran a databse check and the datase is fine.
My question is why is the SMSS database properties window failing an a lock request while de dynamic databse views work properly. Can an application prevent SSMS being used?