I often get the aloof error message above, after trying change a view in SQL Managment Studio 2008. I right-click on a view, select 'design', make a change (or not), and click the Save button.
It only happens on some Views. Others save instantly. I also can't delete or rename this View, and instead get the error "lock request timeout period exceeded… ..@objname is ambiguous or claimed @objtype (OBJECT) is wrong." Can I remove this lock, assuming that really is the problem?
Is there a way to fix, or get around this bug in SSMS? It's happening more and more, maybe because my queries are getting larger? I don't know.
Edit: After more reasearch I see this bug is identified by the 1222 error, and MSDN has directions for a workaround, which states:
"Use sys.dm_os_waiting_tasks and sys.dm_tran_locks dynamic management views"
Currently I'm trying to figure out what "Use sys.dm_os_waiting_tasks" really means.
Best Answer
"Use sys.dm_os_waiting_tasks" means to run queries against that object to see what's causing the timeouts that you are getting.