首页 > 编程 > VBScript > 正文

查看SQL状态的vbs

2020-06-26 18:21:43
字体:
来源:转载
供稿:网友
检验SQL SERVER是否在这机器上工作
 

 

复制代码代码如下:

'**************************** 
'*by r05e 
'*检验SQL SERVER是否在这机器上工作 
'**************************** 
strComputer = "." 
Set objWMIService = GetObject("winmgmts:" _ 
& "{impersonationLevel=impersonate}!//" & strComputer & "/root/cimv2") 
Set colServices = objWMIService.ExecQuery _ 
("Select * from Win32_Service Where Name = 'MSSQLServer'") 
If colServices.Count > 0 Then 
For Each objService in colServices 
Wscript.Echo "SQL Server is " & objService.State & "." 
Next 
Else 
Wscript.Echo "SQL Server is not installed on this computer." 
End If 

 

 

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表