Please note that above script will only tells you which query is running, not the actual progress of the query. Unfortunatly there is no way to know the actual progress of the query :(.
You can use Activity Monitor from management studio or use sp_who2 or below query to know the session id
Plesae comment if you like this script or if have better script/way or if you find any error in this script or any aditional information about this.
MS SQL 2008 | MS SQL 2008 R2 | MS SQL 2012 | T-SQL | T-SQL Tutorials | Learn T-SQL | | Microfot SQL Server | MS SQL Server Admministration | How to know current running query | How to know current running query from SP