Welcome to Sign in | Help

Re: intrebare de incepator

  •  04-12-2009, 6:36 PM

    Re: intrebare de incepator

    Salvează (sqlserver.vbs) şi executa următorul script WMI VB Script pentru a vedea dacă serviciul SQL Servere este pornit (Running):
    strComputer = "."

    Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=Impersonate}!\\" & strComputer & "\root\cimv2")

    Set colServices = objWMIService.ExecQuery("Select * From Win32_Service Where State = 'Running'")

    For Each objService in colServices

    If objService.Name = "MSSQLSERVER" Or Left(objService.Name, 6) = "MSSQL$" Then

    Wscript.Echo objService.Name & " is " & objService.State

    End If

    Next

    MsgBox "End"


    Ce afişează ?

    Sau:
    Start > Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager > nodul SQL Server services - servicii SQL Server > care este starea serviciului/serviciilor MSSQLSERVER sau MSSQL$... ?

    Dacă serviciul este oprit porneşte serviciul: click dreapta > Start (tot in SSCM) !


View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems