Quick query to return currently restoring databases
People need weird thigns for weird reasons. Well, if the thing you need just happens to be:
List of databases that are currently in Restoring... state
We can help. Just run:
SELECT percent_complete , *
FROM sys.dm_exec_requests
WHERE command In ( 'RESTORE DATABASE' )
