How can I rebuild an index on table with 100 million rows without a wait time out?
Community Wiki answer for the solution originally provided in a question comment:


  Martin Smith: Run the script through a new query window in SSMS. Not through the visual designer.