使用 ManagementObjectSearcher 获取 Sql Server 2008 的安装根目录的 SqlServiceAdvancedProperty 名称？

发布于 2024-10-03 04:24:00 字数 474 浏览 4 评论 0原文

我正在使用 ManagementObjectSearcher 查询有关已安装的 Sql Server 实例的信息，例如：

 [String].Format("select * from SqlServiceAdvancedProperty 
                   where SQLServiceType = 1 and PropertyName = '{0}' 
                     and ServiceName = '{1}'", propertyName, serviceName)

此方法非常适合 InstanceID、Version 和 SKUName，但现在我也尝试查找安装根目录。对于 SQL 2005，属性名称似乎是 SqlDataRoot，但此后已被弃用。

有人知道用于获取数据目录的正确属性名称，甚至只是 Sql Server 的安装目录吗？即使只是列出可以查询的可能属性也会有巨大的帮助。

原文

I'm using a ManagementObjectSearcher to query information about installed Sql Server instances, for example:

 [String].Format("select * from SqlServiceAdvancedProperty 
                   where SQLServiceType = 1 and PropertyName = '{0}' 
                     and ServiceName = '{1}'", propertyName, serviceName)

This method works great for InstanceID, Version and SKUName but now I'm trying to find the installation root as well. For SQL 2005 it appears the property name was SqlDataRoot, but has since been depreciated.

Anybody know the correct property name to use to get the data directory, or even just install directory for Sql Server? Even just a list possible properties that can be queried would be an enormous help.

分享到QQ

分享到微博