SQL Server 2005 introduces Dynamic Management View, one of this objects allows us monitoring the progress for different tasks and process in SQL Server.
select percent_complete, estimated_completion_time, cpu_time, total_elapsed_time, *
from sys.dm_exec_requests
this query is very helpful in the daily work to monitoring different tasks.
EmoticonEmoticon