SQL Server Usage Notes

1. Querying the current connection status of the database

SELECT * FROM [Master]. [dbo]. [sysprocesses]
WHERE [DBID] In (SELECT [DBID] from [master].[ DBO]. [sysdatabases]
WHERE name= ' DatabaseName ')

2. Viewing the connection after a user logs in through a stored procedure

sp_who ' LoginName '
LoginName is of course the user name of the login SQL, the general program will use a username to log in to the SQL so that the user name can be seen after the login of the connection.
If you do not write loginname, then all SQL Server database connections are returned.

SQL Server Usage Notes