How do I see active SQL Server connections?

by

You can use the sp_who stored procedure.

Provides information about current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine. The information can be filtered to return only those processes that are not idle, that belong to a specific user, or that belong to a specific session.

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. T-SQL split string
  3. How can I get column names from a table in SQL Server?
  4. Conditional WHERE clause in SQL Server
  5. How can I select the first day of a month in SQL?
  6. GROUP BY to combine/concat a column [duplicate]
  7. Select statement to find duplicates on certain fields
  8. Copy data into another table
  9. Using a Variable in OPENROWSET Query
  10. How to find current transaction level?
  11. EXISTS vs JOIN and use of EXISTS clause
  12. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  13. Why is a UDF so much slower than a subquery?
  14. Split function in SQL Server 2008
  15. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  16. Remove numbers from string sql server
  17. Alternate of lead lag function in SQL Server 2008
  18. How do I edit a table in order to enable CASCADE DELETE?
  19. UNIX_TIMESTAMP in SQL Server
  20. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  21. How can I group by date time column without taking time into consideration
  22. The transaction log for the database is full
  23. Generate random int value from 3 to 6
  24. Add emoji / emoticon to SQL Server table
  25. Backup a single table with its data from a database in sql server 2008
  26. COALESCE Function in TSQL
  27. Cannot Resolve Collation Conflict
  28. Try_Convert for SQL Server 2008 R2
  29. Display next event date
  30. Sql query for tree table

Leave a Comment