Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
Please be careful while executing this script as it will start the reindexing.
First run the script till the cursors portion as the cursors are used to execute the reindex statements.
If the database size is small you can the run the entire script.
The two select statements in the script will provide you the list of indexes to rebuild and reorg.
Need Automated Script