Sean, I think dastagiri is asking about rebuilding indexes.
Unless you give online option, the table will be locked until the clustered index is rebuilt.
With online option there will locks towards the end of the operation.
----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]