欧美性猛交XXXX免费看蜜桃,成人网18免费韩国,亚洲国产成人精品区综合,欧美日韩一区二区三区高清不卡,亚洲综合一区二区精品久久

#SQL Server服務(wù)列表，本機使用"."來(lái)描述

PC,ServerNr,SQLServer,Agent,FullTextSearch

VM162,1,MSSQL$SQL2005DE1,SQLAgent$SQL2005DE1,msftesql$SQL2005DE1

VM162,2,MSSQL$SQL2005DE2,SQLAgent$SQL2005DE2,msftesql$SQL2005DE2

… …

PC20,1,MSSQL$SQL01,SQLAgent$SQL01,msftesql$SQL01

PC20,2,MSSQL$SQL02,SQLAgent$SQL02,msftesql$SQL02

… …

.,2,MSSQL$SQL2005DE2,SQLAgent$SQL2005DE2,msftesql$SQL2005DE2

.,3,MSSQL$SQL2005DE3,SQLAgent$SQL2005DE3,msftesql$SQL2005DE3

.,4,MSSQL$TEST,SQLAgent$TEST,msftesql$TEST

#===============配置部份===========================
$User='HQ\Andy';
$CsvFile='E:\Stop&StartSQLServer\SQLSeverList.csv'


#==============可輸入部份(開(kāi)始)====================

$PC="VM162"           #本機使用"."來(lái)描述,非本機使用電腦名稱(chēng)

$ServerNr=4     #SQL Server實(shí)例編號,來(lái)源于SQLSeverList.csv文件

$ActionType=0     # 1: 開(kāi)啟服務(wù) ,0: 停止服務(wù)

#==============可輸入部份(結束)====================
<#

“===可控制的服務(wù)列表: ”
Import-Csv -Path $CsvFile | Format-Table -AutoSize -Wrap

#>
try
{
    $ServiceStr=Import-Csv -Path $CsvFile | Where-Object -FilterScript {($_.PC -eq $PC) -And ($_.ServerNr -eq $ServerNr)}
    
    if ($PC -ne ".")  #本機
    {
        $Credential_Login=Get-Credential -Credential $User
        $Service_Agent=Get-WmiObject -Class Win32_Service -ComputerName $PC -Credential $Credential_Login | Where-Object -FilterScript {$_.Name -eq $ServiceStr.Agent}
        $Service_SQLServer=Get-WmiObject -Class Win32_Service -ComputerName $PC -Credential $Credential_Login | Where-Object -FilterScript {$_.Name -eq $ServiceStr.SQLServer}
        $Service_FullTextSearch=Get-WmiObject -Class Win32_Service -ComputerName $PC -Credential $Credential_Login | Where-Object -FilterScript {$_.Name -eq $ServiceStr.FullTextSearch}
    
    }
    Else #網(wǎng)絡(luò )
    {
        $Service_Agent=Get-WmiObject -Class Win32_Service | Where-Object -FilterScript {$_.Name -eq $ServiceStr.Agent}
        $Service_SQLServer=Get-WmiObject -Class Win32_Service | Where-Object -FilterScript {$_.Name -eq $ServiceStr.SQLServer}
        $Service_FullTextSearch=Get-WmiObject -Class Win32_Service | Where-Object -FilterScript {$_.Name -eq $ServiceStr.FullTextSearch}
    
    }
    
    
    $Running="Running"
    $Stopped="Stopped"
    
    If ($ActionType -eq 1) #Start Service
    {
        if ($Service_SQLServer.State -eq $Running)
            {$Service_SQLServer.Name +" 正在運行"}
        Else 
            {$Result=$Service_SQLServer.StartService()}
            
        if ($Service_Agent.State -eq $Running)
            {$Service_Agent.Name +" 正在運行"}
        Else 
            {$Result=$Service_Agent.StartService()}
        
        if ($Service_FullTextSearch.State -eq $Running)
            {$Service_FullTextSearch.Name +" 正在運行"}
        Else 
            {$Result=$Service_FullTextSearch.StartService()}                  
    }
    Else #Stop Service
    {
        if ($Service_FullTextSearch.State -eq $Stopped)
            {$Service_FullTextSearch.Name +" 已停止."}
        Else 
            {$Result=$Service_FullTextSearch.StopService()}
        
        if ($Service_Agent.State -eq $Stopped)
            {$Service_Agent.Name +" 已停止."}
        Else 
            {$Result=$Service_Agent.StopService()}
        
        if ($Service_SQLServer.State -eq $Stopped)
            {$Service_SQLServer.Name +" 已停止."}
        Else 
            {$Result=$Service_SQLServer.StopService()}                    
    }
    
    "命令處理OK!"
    
}
Catch
{
    Write-Warning "執行腳本過(guò)程發(fā)生錯誤"
    Write-Error $_ #輸出當前錯誤內容
}