After restoring database from a SQL 2000 instance to SQL 2005 and setting up a maintenance plan to do an on-line Index Rebuild task, the following error is generated:
Failed:(-1073548784) Executing the query "ALTER INDEX [pk_dtproperties] ON [dbo].[dtproperties] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = ON )
" failed with the following error: "Online index operation cannot be performed for index 'pk_dtproperties' because it contains column 'lvalue' of data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max) or xml. The operation must be performed offline.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
The dtproperties table also has zero rows, and changing the compatibility level to SQL 2005 didn't appear to have any affect. As an FYI, the failure doesn't tell you anything in the maintenance plan history or the job output file about the db that the failure occurred in either.
Should the dtproperties table be dropped as I see it isn't created in databases created on the SQL 2005 instance
Maintenance Plans and dtproperties table