Tagged: SQL Server’da Port ve Host Bilgilerini Öğrenmek

SQL Server’da Port ve Host Bilgilerine Erişmek

SQL Server’da Port ve Host Bilgilerine Erişmek

Herkese merhaba, Bu kısımda SQL Server’da port ve host bilgilerine erişme kodları olacak. SELECT s.host_name ,c.local_net_address ,c.local_tcp_port ,s.login_name ,s.program_name ,c.session_id ,c.connect_time ,c.net_transport ,c.protocol_type ,c.encrypt_option ,c.client_net_address ,c.client_tcp_port ,s.client_interface_name ,s.host_process_id ,c.num_reads as num_reads_connection ,c.num_writes as num_writes_connection ,s.cpu_time ,s.reads as num_reads_sessions ,s.logical_reads as num_logical_reads_sessions ,s.writes as num_writes_sessions ,c.most_recent_sql_handle FROM sys.dm_exec_connections AS c INNER JOIN...

Yazı kopyalamak yasaktır!