1

Resolved

fillfactor' is not a recognized ALTER INDEX REORGANIZE option

description

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.
 
Any suggestions?

comments

jaspersmith wrote May 29, 2008 at 5:47 AM

Having investigated the issue, this is due to a bug in SMO for indexes with a non default fillfactor. I have coded a workaround and am currently testing it and a new release will be available soon that fixes this issue.

jaspersmith wrote Jul 4, 2008 at 10:58 AM

I have added a fix for this SMO bug in version 1.5.0.0