How to: Check the DB Shrink Completion Status?

You need to find out which SPID is currently running. Execute the following script to find out.

sp_who2 active

After that, replace the in the following script with the SPID you find in the list above.

Select 
	start_time
	, command
	, blocking_session_id
	, percent_complete
	, CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ' hour(s), '
                  + CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + 'min, '
                  + CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ' sec' as running_time
	, CAST((estimated_completion_time/3600000) as varchar) + ' hour(s), '
                  + CAST((estimated_completion_time %3600000)/60000 as varchar) + 'min, '
                  + CAST((estimated_completion_time %60000)/1000 as varchar) + ' sec' as est_time_to_go
from sys.dm_exec_requests 
where session_id = '<SPID>'