1. Bpr New Member

   We have a process that rebuilds indexes using "alter index rebuild online". However, if there is an existing "select" query running, it blocks the "alter index". Why is this happening even though we are using the "online" option?

   Bpr, Nov 29, 2012

   #1
2. FrankKalis Moderator

   See if this helps: http://www.sqlskills.com/blogs/paul...ne-index-operations-do-not-acquire-locks.aspx

   FrankKalis, Nov 29, 2012

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in