Archive

Archive for the ‘Upgrade’ Category

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

March 26th, 2013 DynamicsMSCRM Comments off

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