请帮我有关sql [英] Please help me about sql

问题描述

在SQL中，我会知道到数据库有多少个连接以及这些连接的IP是什么?
请帮助我

In SQL, I''d know how many connection to database and What''s IP of these connection?
Please help me

推荐答案

尝试:

EXEC sp_who

这将为您提供主机名，然后您可以使用它来访问IP:http://www.sqlserver2005.de/Articles/3/ [

That will give you the hostname, you can then use that to access the IP: http://www.sqlserver2005.de/Articles/3/[^]

从以下地址获取网络地址，主机名:

Get net_address, hostname from:

select net_address, hostname
from master.dbo.sysprocesses

从以下位置获取client_net_address:

Get client_net_address from:

SELECT client_net_address
FROM sys.dm_exec_connections

请帮我从2个表 sysprocesses，dm_exec_connections

Please help me get net_address, hostname, client_net_address from 2 tables sysprocesses, dm_exec_connections

这篇关于请帮我有关sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！