I tried to download it and have a look, but the download link was broken :/

My guess is that it is executing the procedures in order to look at the result sets and get the meta data that way...

Try it on this proc:

CREATE PROCEDURE stproc_Test

AS

WAITFOR DELAY '00:00:20'

SELECT 'hello'

If it takes about 20 seconds to get the result sets, then it's executing them. If not, then it's probably doing something really quite complicated under the hood.

The other way you can find out what it is doing is to run a profiler trace, and see what it executes. Let me know what you find 🙂