When a process (e.g. SP) is running, it sometimes will return results as it is running, with ADS, you do not get to see any results until it is completed. SQL Management Studio gives you an option to look at Messages as it runs, I would like to see that option in ADS.