This project is read-only.

'fillfactor' is not a recognized ALTER INDEX REORGANIZE option

May 2, 2008 at 3:09 PM
While trying to run a reorg command against a user database, I get the following error.

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.

Any suggestions?
Jul 4, 2008 at 11:51 AM
This is a known bug in SMO (see Connect Item 339570). I have added a workaround fix for this in Expressmaint
Jul 9, 2008 at 5:58 PM
Upgrading to expressmaint seems to have done the trick so far - thanks!