So I was tasked with adding an Identity column to a very large table this weekend. Yesterday it failed because the Transaction Log ran out of room (DB is in simple recovery.) So I re-set things up today, gave the TLog an extra file on another disk to try to prevent the out-of-log-space error, and fired off the alter table command.
And went to get breakfast.
And had the GPO enforced RDP log off kick in while I was gone.
Forcing SSMS to close (I was RDPed into the server.)
It looks like my alter table might still be running (based on sys.dm_exec_requests and grabbing the text from sys.dm_exec_sql_text) but is there any way to be sure? Exec_Requests currently shows the process as suspended with a wait_type of pageiolatch_ex, so I'm presuming it's waiting on the disk system before continuing.