34,576
社区成员
发帖
与我相关
我的任务
分享
net start MSSQL$CNWZH
-->1启用xp_cmdshell
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
-- 启用xp_cmdshell
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO
-->2查询OS中与数据库相关的服务名
declare @a table (a varchar(200))
insert into @a
exec xp_cmdshell 'sc query state= all'
select CASE WHEN a LIKE '%$%'
THEN '命令实例 '+REPLACE(a,'SERVICE_NAME: ','')
ELSE '默认实例 '+REPLACE(a,'SERVICE_NAME: ','') END
as 服务名
from @a
where a like 'SERVICE_NAME: MSSQL%' and LEN(a) < 28
-->result:
服务名
---------------------------------------
命令实例 MSSQL$SQL2K
默认实例 MSSQLSERVER
(2 行受影响)