Monitor SQL connection from. Net sqlclient data provider

You can use the following SQL script to monitor SQL Server Processes and connections, whose function is almost the same as sp_who & sp_who2.

Select Spid, uid = Rtrim (Loginame), program_name = Rtrim (Program_name ),
Dbname = Db_name (Dbid), status = Rtrim (Status)
From Master. DBO. sysprocesses
Where Loginame = ' Sa or other Login Name '   And   Db_name (Dbid) = ' Database Name '  
  And Program_name = ' . Net sqlclient data provider '

Eg.
Select Spid, uid = Rtrim (Loginame), program_name = Rtrim (Program_name ),
Dbname = Db_name (Dbid), status = Rtrim (Status)
From Master. DBO. sysprocesses
Where Loginame = ' SA '   And   Db_name (Dbid) = ' Hris2004 '  
  And Program_name = ' . Net sqlclient data provider '