2

When running sp_blitzFirst @expertmode = 1 the first result set(result set of sp_blitzwho)does not return nearly as many columns and it does in Brent's video. With a little troubleshooting it was uncovered that the reason this is happening is because the calling stored procedure is not passing @expertMode = 1 to sp_blitzWho. To prove that i can run sp_blitzWho and pass @expertMode = 1 in which case the etire result set is returned.

So my question is: Was there a change to latest version of these stored procedures? Where can i find the version that work like the one Brent displays in his video? Thank you for looking in to this. Best Regards.

Brent Ozar
  • 43,325
  • 51
  • 233
  • 390
Steve Rybak
  • 21
  • 1

1 Answers1

1

You're watching a 4-year-old video on YouTube, and sp_BlitzFirst no longer works that way.

If you want to run sp_BlitzWho with @ExpertMode = 1, your best bet is to go ahead and call it directly.

Brent Ozar
  • 43,325
  • 51
  • 233
  • 390