Home > 2011, Deployment Manager, Import Organization, Upgrade > MS CRM 2011 Fragmented indexes were detected in the Microsoft Dynamics CRM database

MS CRM 2011 Fragmented indexes were detected in the Microsoft Dynamics CRM database

March 26th, 2013 DynamicsMSCRM

During the import of an organization an error message may display “Fragmented indexes were detected in the Microsoft Dynamics CRM database”

Re-index the organisation databases

USE Org_MSCRM
GO
EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 80)”
GO
EXEC sp_updatestats
GO

  • Share/Bookmark
Comments are closed.