>Hi
>
>Do I need to ensure everyone is disconnected before running a reindex.
>
>If there are people using the database how does that affect a reindex.
>
>Thanks
It depends on your SQL Server version. Enterprise / Developer version allows indexing while using a table.
If it's not broken, fix it until it is.
My Blog