Rob44 (3/8/2010)
Let's suppose the command returns 0! What's the next step if the rebuild of the index in the maintenance plan is unsuccessful?
We can give manual run to ALTER INDEX [PK__EventStage__46AF6B36] ON [Event].[EventStage] REORGANIZE WITH ( LOB_COMPACTION = OFF )
and see if problem persists or not
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)