How to view the current active connection of a database in real time

Data | database
Has been plagued by this problem, a few days ago on the Internet to find solutions. Now share the following:
Basic statement is sp_who
We can insert the query results into our own defined table (Monitoruser)
The base statement is
CREATE Table Monitoruser
(spid int,
ecid int,
Status varchar (200),
Loginame varchar (200),
Hostname varchar (200), \ \ New table structure based on sp_who results
Blk varchar (200),
dbname varchar (200),
CMD varchar (200),
[DateTime] [DateTime] Not NULL
)
ALTER TABLE [dbo]. [Monitoruser] With NOCHECK ADD
CONSTRAINT [DateTime] DEFAULT (getdate ()) For[datetime] \ Automatic fetch time to DateTime column
Go
Insert into Monitoruser (spid,ecid,status,loginame,hostname,blk,dbname,cmd)
EXEC (' sp_who ') \ Execute sp_who and insert the result into Monitoruser