Skip to main content
A
akuzemd30137128
Participant
October 18, 2017
Answered

Reindexing Database in SQL Server Express 2008

  • October 18, 2017
  • 1 reply
  • 1149 views

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?

This topic has been closed for replies.
Correct answer Annkiit

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

1 reply

Annkiit
Adobe Employee
AnnkiitCorrect answer
Adobe Employee
October 18, 2017

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices