Reindexing Database in SQL Server Express 2008

[akuzemd30137128]

Our Adobe Connect version is '8.2.2.7a'. We want to reindex Adobe Connect database but we have SQL Server Express 2008.

We know that SQL Server Express 2008 doesn't support reindexing.

How can we reindex database using SQL Server Management Studio or an external tool?

[Annkiit · Accepted solution]

Hi,

You can use below script to reindex DB.  Take the backup beforehand.

--Script to automatically reindex all tables in a database

USE breeze --Enter the name of the database you want to reindex

GO

EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"

GO

EXEC sp_MSforeachtable @command1=" UPDATE STATISTICS ?"

GO

Hope this helps.

Thanks,

Annkiit