All geek questions in one place

Active session mapping in SQL Server 2005

Possible duplicate:
How to determine the total number of open / active connections in ms sql server 2005

Oracle has a view called V $ SESSION that lists all active sessions in the database. Is there a similar view in SQL Server 2005?

+3
source share
2 answers

The usual one sp_who.

+6
source

select * from sys.sysprocesses

can be used instead of v $ session in oracle

http://silverlightedworld.blogspot.com/2009/04/vsession-for-oracle-and-sql-server.html

Renju Relations www.renjucool.co.nr

+3
source

Source: https://habr.com/ru/post/1699030/

More articles:


All Articles