Rebuild failed for index Execution timeout expired

Issue

In MS SQL Server 2019 RTM version, you may intermittently see index rebuild failures when attempted using SQL Server Management Studio (SSMS) i.e by navigating using Databases => Database name => Table name => Indexes => Index name (right click) => Rebuild => Script Action to New Query Window

This can occur even if the ONLINE checkbox is unchecked. So, this error can occur with or without the ONLINE option.

Error messages

Rebuild failed for index

An exception occurred while executing a Transact-SQL statement or batch.

Execution Timeout Expired

The wait operation timed out.

    

Workaround

Try the manual method i.e by directly typing and executing the SQL statement "ALTER INDEX..."