About Author: Emre BAŞTUĞ

SELECT connect_time,client_net_address,local_net_address,net_transport,protocol_type,auth_scheme,last_read, last_write FROM sys.dm_exec_connections where local_net_address!=” and client_net_address!=‘127.0.0.1’ order by connect_time desc SELECT HOST_NAME() AS HostName, SUSER_NAME() LoggedInUser     SELECThostname,loginame,program_name,cmd,status,last_batch,login_time FROM sys.sysprocesses where status=‘runnable’

Continue Reading...