The index was heavily fragmented so I wanted to compare the rebuild vs the drop and create.

Thanks for the reply Steve.

We have decided to set the Recovery Model of the database to Bulk-logged and then drop and recreate the index. After creating the index we...

Thanks Steve that was it.

I appreciate yours and Carolyn’s suggestions.

Thanks

If you mean the user that can start and run sql server; then yes they are.

The database has been moved from one server to another. The users I can...