aliskumardba (4/3/2012)
So what to do then? I am using SQL server 2008r2 Standard edition on PROD server. I can't block users while I am defragmenting indexes. Is there any option in SQL server configuration or in database configuration where we can find this online option and can make it to available while we rebuliding indexex?Please help.
Nope, online rebuild is only available in the Enterprise (and developer) Editions. If you need to rebuild your indexes you will need to find a time when database use is low and blocking can be somewhat tolerated, or you will need to find a maintenance window when you can block users from accessing the database and complete the rebuild of the indexes.
Your only other choice at this time is to reorganize the indexes.