Home Forums SQL Server 2005 Administering BLOCKING CAUSED BY REORGANIZE OF INDEX JOB IN SQL SERVER 2005 RE: BLOCKING CAUSED BY REORGANIZE OF INDEX JOB IN SQL SERVER 2005

  • john

    yes i have automatic blocking alert also with the details which is causing the blocking with query and time and etc .

    but here my question is when i reorganize the index why the blocking occurs which should not come as per the reorganize index criteria reorganize of index is online and lock does not occurs at that point of time as the index are available for use.