Sql Server a bağlı Uzak IP leri Görme

Makaleyi Paylaş

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

sql_3

SELECT HOST_NAME() AS HostName, SUSER_NAME() LoggedInUser

sql_2

    SELECThostname,loginame,program_name,cmd,status,last_batch,login_time
FROM sys.sysprocesses where status=‘runnable’

sql_1

Tags:

About Emre BAŞTUĞ

Emre BAŞTUĞ