I tried to rebuild indexes on a large table from SSMS RC Table->Indexes->Rebuild All. the PK index rebuild failed while others succeeded. This was due to insufficient disk space in Primary file group. The disk was almost full, I made 45GB by moving a backup file. Four days later the Rebuild Indexes window still says "Executing" (Please see attached screenshot)![alt text] and so I get a warning when trying to exit the SSMS "Closing this application may terminate this process: Rebuild Indexes". How can I tell if the rebuild indexes process has completed and if I can close this window. Is there anything I should do look for here? : /storage/temp/3174-rebidxwin.jpg
I suspect the process is already dead, just that the window doesn't recognize it. However, to be sure, you can run a query against sys.dm_exec_requests to identify any outstanding processes that are running, or locked, blocked, waiting on a task. That's the best way I know to check on the status of operations within the system. You might need to join to sys.dm_exec_sql_text in order to see the queries. If you do a search on these DMVs, you'll get lots of examples.