There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
fillfactor' is not a recognized ALTER INDEX REORGANIZE option
While trying to run a reorg command against a user database, I get the following error. This is happening on more then one server, on different databases.
Reorganizing indexes for table dbo.dtproperties
Reorganizing indexes for table dbo.Groups
Reorganize failed for Index 'PK_Groups'.
An exception occurred while executing a Transact-SQL statement or batch.
'fillfactor' is not a recognized ALTER INDEX REORGANIZE option.
I seem to be able to manually run a rebuild or reorganize on the index from within SQL Management Studio Express.
The database was originally created on a SQL 2000 Server, and was attached to SQL 2005 Express.