Adam Machanic (7/8/2010)
larry.meklemburg (7/8/2010)
I believe it is exactly what occurs in John's case. Thanks for the idea. I will try running Adam's whoisactive script when I next get the error.As a note, I just ran your script and the error did not occur. I will keep you informed and thanks.
Not trying to overshadow the work that Jason has done, but why not just stick with Who is Active? It doesn't have the error and returns all of the same data plus a lot more 🙂
Not a bad choice. Mine is by no means meant as a competitor to whoisactive.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events