Skip to main content
Synthetic Realities
Shopping cart
Empty
For enquiries:
synthetic.realities@outlook.com
0409 048 621
  • home
  • About us
  • Blogs
  • Contact us

Categories

  • Business Processes
  • Business Tools
  • DBA Tools
  • SQL Scripts
  • Software

Blogs

Clearly Viewing Database Activity with SP_WHO2

One of the most commonly used stored procedures within SQL server is SP_WHO2, as it shows all the sessions that are currently established in the database. These are denoted as SPID‘s, or Server process Id’s. The following SQL query is useful for formatting the output, to filter out system database activity and ordering the output per database.

  • Read more about Clearly Viewing Database Activity with SP_WHO2
  • Anonymous's blog

Go Live 10/05/2018

“Although this may be a most difficult thing, if one will do it, it can be done. There is nothing that one should suppose cannot be done.”
- Yamamoto Tsunetomo

  • Read more about Go Live 10/05/2018
  • Anonymous's blog

Order support

  • Customer Service

Product support

  • Purchases and GST

Legal

  • Terms and Conditions
  • Returns & Refunds
  • Business Contact Details
  • Privacy