从本地网络中的servername获取所有数据库名称 [英] Fetching all database name from servername in local network

问题描述

我想从服务器名称访问整个本地数据库，但只获取单个系统详细信息。



我尝试过： < br $>

I want to access entire local database from server name ,but getting only single system details.

What I have tried:

SELECT	@@SERVERNAME as ServerName,
		DB_NAME(dbid) as DBName, 
		hostname as MachineName ,
		COUNT(dbid) as NumberOfConnections,
		loginame as LoginName,
		ConnectionProperty('client_net_address') AS 'Client Net 			Address'
		
--FROM sys.sysprocesses with (nolock) 
FROM sys.sysprocesses
WHERE dbid > 0 
and len(hostname) > 0 
and DB_NAME(dbid)=; 
Group by DB_NAME(dbid),hostname,loginame
order by DBName

推荐答案

你的机器是连接吗？



如果是，那么当时是否有其他人连接到数据库？



BTW，摆脱和DB_NAME（dbid）=; 行。你的示例查询不会像你那样在sql server中执行。



编辑================ ==============



我发现谷歌（搜索短语=sql server获取所有当前连接）。

Is that connection your machine?

If so, is anyone else connected to the database at the time?

BTW, get rid of the and DB_NAME(dbid)=; line. Your example query won't execute in sql server the way you have it there.

EDIT ==============================

I found this with google (search phrase="sql server get all current connections").

DECLARE @SPWHO2 TABLE 
    ([SPID] VARCHAR(1000),
     [Status] VARCHAR(1000) NULL, 
     [Login] VARCHAR(1000) NULL, 
     [HostName] VARCHAR(1000) NULL, 
     [BlkBy] VARCHAR(1000) NULL, 
     [DBName] VARCHAR(1000) NULL, 
     [Command] VARCHAR(1000) NULL, 
     [CPUTime] VARCHAR(1000) NULL, 
     [DiskIO] VARCHAR(1000) NULL, 
     [LastBatch] VARCHAR(1000) NULL, 
     [ProgramName] VARCHAR(1000) NULL, 
     [SPID2] VARCHAR(1000) NULL, 
     [Request] VARCHAR(1000) NULL)
INSERT INTO @SPWHO2 
    EXEC sp_who2 'Active'
SELECT * FROM @SPWHO2

我是现在唯一登录我服务器的人，所以它只显示一条记录，所以我无法确定这是否是你需要的。

I'm the only person logged into my server right now, so it only shows one record, so I cannot determine if this will be what you need.

这篇关于从本地网络中的servername获取所有数据库名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！