All SQL Server Session information in a SQLServer

How to get all session id's information which are connected to the database



select * from sysprocesses