Friday, March 22, 2013

Fragmented indexes were detected in the Microsoft Dynamics CRM database

Re-index your CRM Org database if you receive this error.

USE Org_MSCRM
GO
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
GO 

No comments: