>>How can I see what is happening during a fairly long query execute? The little swirling circle just isn't enough for me.
>
>Apparently there is no progress in SSMS. See http://ieeexplore.ieee.org/iel5/9680/30564/01410198.pdf?isnumber=30564&prod=CNF&arnumber=1410198&arSt=+853&ared=+864&arAuthor=Gang+Luo%3B+Naughton%2C+J.F.%3B+Ellmann%2C+C.J.%3B+Watzke%2C+M.W.

I did find out that if I switch to the Messages tab and I put a PRINT in the query, then I can see that as it loops through. Kind of like a WAIT WINDOW in Foxpro. Or more like using ? really.