MSSQL状态和版本 [英] MSSQL status and version

问题描述

我们如何使用C ++/CLI .NET(WMI，注册表)在远程计算机中找到以下MSSQLServer信息:

How do we find the following information of MSSQLServer in a remote machine using C++/CLI .NET (WMI, registry):

1. 是否已安装
   
2. 版本
   
3. 状态
   

1. Installed or not
   
2. Version
   
3. Status
   

感谢您的帮助.

Any help is appreciated.

推荐答案

如果知道计算机的名称，则可以使用以下方法获取有关所有正在运行的SQL实例的信息，然后可以在返回的集合中查找名称:SqlDataSourceEnumerator.GetDataSources方法 [

Hi,

If you know what the machine name is, when you could make use of the following method to get some information about all the SQL instances running, you could then look-up the name within the returned collection: SqlDataSourceEnumerator.GetDataSources Method [^].

You should get a collection of rows (DataTable) that has the following columns:

- ServerName
- InstanceName
- IsClustered
- Version

Kind regards,

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