dbcc reindex

If dbcc reindex attempts to lock a table for reindexing,
but can't get exclusive access, does it just sit there
interminably? If so, can I use "set lock timeout" to make
it skip tables on which it cannot get exclusive locks?Yes, it will just wait to get the locks it needs for the reindex and yes,
you can use the lock_timeout to make it skip the locked table.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"superboy" <anonymous@.discussions.microsoft.com> wrote in message
news:016501c3da14$cf13d390$a601280a@.phx.gbl...

quote:

---

> If dbcc reindex attempts to lock a table for reindexing,
> but can't get exclusive access, does it just sit there
> interminably? If so, can I use "set lock timeout" to make
> it skip tables on which it cannot get exclusive locks?

---