sql-server – 如何在没有安装SSMS的情况下找到SQL Server版本/

我查看了程序菜单,发现安装了配置管理器,否则,它是相当简单的.我点击了EXE文件的属性,找到了10.50.1600.1,但是我发现没有地方说明是Express,Dev,STN,ENT等.

如果我不得不猜测,这是一个快速版本,但我想知道是否有明显的告示标志.

更新：
@Bob – 该文件告诉我我所知道的,而不是版本.

@valo – 当我运行该命令时,我收到以下错误,并且我确实启用了命名管道：

HResult 0x35,Level 16,State 1
Named Pipes Provider: Could not open a connection to SQL Server [53].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance->specific error has occurred while establishing a connection to SQL Server. Server is not >found or not accessible. Check if instance name is correct and if SQL Server is configured >to allow remote connections. For more information see SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

@thomas – 在我问这个问题之前我注意到了股票保持单位名称,但这似乎太容易了,我想我最初的怀疑是正确的.

解决方法

$ComputerName = "YourComputerName"
$ServiceName = 'YourEngineServiceName'
$PropertyName = "SKUNAME"

# retrieve the most current version of the ComputerManagement namespace
#
$ComputerManagementNamespace =
    (Get-WmiObject -ComputerName $ComputerName -Namespace "rootmicrosoftsqlserver" -Class "__NAMESPACE" |
        Where-Object {$_.Name -like "ComputerManagement*"} |
        Select-Object Name |
        Sort-Object Name -Descending |
        Select-Object -First 1).Name

if ($ComputerManagementNamespace -eq $null) {
    Write-Error "ComputerManagement namespace not found"
}
else {
    $ComputerManagementNamespace = "rootmicrosoftsqlserver" + $ComputerManagementNamespace
} 

# get the property and its value
#
Get-WmiObject -ComputerName $ComputerName -Namespace $ComputerManagementNamespace -Class "SqlServiceAdvancedProperty" |
    Where-Object {
        $_.ServiceName -eq $ServiceName -and
        $_.PropertyName -eq $PropertyName
    } |
    Select-Object @{Name = "ComputerName"; Expression = { $ComputerName }},ServiceName,@{Name = "PropertyValue"; Expression = {
            if ($_.PropertyValueType -eq 0) {
                $_.PropertyStrValue
            }
            else {
                $_.PropertyNumValue
            }
        }}

同样,可以在SQL Server配置管理器工具中直接找到相同的信息.打开它后,右键单击SQL Server服务并进入“属性”.然后单击“高级”选项卡,查看“库存保持单元名称”键.你会找到你正在使用的版本.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!