Home Forums SQL Server 2005 Administering Page level locking disable/enable during alter index reorganize RE: Page level locking disable/enable during alter index reorganize

  • I know the post is a bit old but I just wanted to add that I've successfully done this and have not seen any adverse issues on both 2008 and 2012. I do not use the maintenance plans however, I use a T-SQL job.

    edit: sorry, I'm too dumb to see what thread I'm in, I have not done this in 2005, however, I still can't think of any issues, especially if you're saying that you have a maintenance window. I actually do mine without a maintenance window.