Error displays "Online index operation cannot be performed on clustered index as index contains column of data type text, nvarchar." when a Rebuild Index task is included in a LiteSpeed for SQL Server Maintenance Plan.
Clustered Indexes may not be rebuilt when online
WORKAROUND1:
For SS 2005 - 2008 R2, try:
SELECT SCHEMA_NAME(T.[schema_id]) AS [schema], OBJECT_NAME(I.[object_id]) AS tn, I.name AS index_name, C.name AS column_name, TY.name AS [type_name], IC.is_included_column FROM sys.tables AS T INNERJOIN sys.indexes AS I ON T.[object_id] = I.[object_id] INNERJOIN sys.index_columns AS IC ON I.[object_id] = IC.[object_id] AND I.index_id = IC.index_id INNERJOIN sys.columns AS C ON IC.[object_id] = C.[object_id] AND IC.column_id = C.column_id INNERJOIN sys.types AS TY ON C.system_type_id = TY.system_type_id WHERE I.type_desc = 'CLUSTERED'AND TY.name LIKE'%char';
WORKAROUND2:
The REORGANIZE INDEX and UPDATE STATISTICS works if the choice FULL SCAN is selected in the UPDATE STATISTICS task.
There is also an application SQLCop and one of the checks it performs is a check for wide clustered index.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center