Getting the status of MS SQL SERVER service - KiXtart.org - official site

You are not logged in. [Log In] KiXtart.org website » Forums » KiXtart » Basic Scripting » Getting the status of MS SQL SERVER service

Page 1 of 1

1

Topic Options

#155212 - 2006-01-13 09:50 AM Getting the status of MS SQL SERVER service
AstaaLavista AstaaLavista Starting to like KiXtart Registered: 2005-08-11 Posts: 111 Loc: Gujarat, India.	Hi All, Is it possible to know the status of MS SQL Server service from Kixtart. Please let me know. Thank you.
Top

#155213 - 2006-01-13 09:54 AM Re: Getting the status of MS SQL SERVER service
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	you wishing to know if the service is up and running versus down or paused? _________________________ ! download KiXnet
Top

#155214 - 2006-01-13 10:03 AM Re: Getting the status of MS SQL SERVER service
AstaaLavista AstaaLavista Starting to like KiXtart Registered: 2005-08-11 Posts: 111 Loc: Gujarat, India.	yeah Jooel ! Basically, i am trying to check the status of the ERRORLOG file in SQL server to check the status of the service, but checking the ERRORLOG file does NOT help. since it is always locked, i have to copy it to some other file & then read it to check for occurrence of statements like (RECOVERY COMPLETE, SQL AGENT STARTED etc.) is there any way available to check the status of service from SERVICE CONTROL MANAGER?
Top

#155215 - 2006-01-13 10:07 AM Re: Getting the status of MS SQL SERVER service
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	yes, like I asked, that level of information is available. but the level you are wishing to see and what log file gives you, is not available via service control. _________________________ ! download KiXnet
Top

#155216 - 2006-01-13 10:10 AM Re: Getting the status of MS SQL SERVER service
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	as example: http://www.kixtart.org/UDF/UDF_lister.php?what=post&code=82457 does provide the current state of the service. _________________________ ! download KiXnet
Top

#155217 - 2006-01-13 11:56 AM Re: Getting the status of MS SQL SERVER service
AstaaLavista AstaaLavista Starting to like KiXtart Registered: 2005-08-11 Posts: 111 Loc: Gujarat, India.	Hi Jooel, Thanks a ton for your help. I got ALL what I wanted. (i didnt know that winmgmts is a function provided by microsoft & it is a really useful function.)
Top

#155218 - 2006-01-15 04:03 AM Re: Getting the status of MS SQL SERVER service
Sealeopard Sealeopard KiX Master Registered: 2001-04-25 Posts: 11165 Loc: Boston, MA, USA	First of all, there are a couple of UDFs that check service status. Secondly, WINMGMTS is a mandatory prefix for a WMI moniker in order to interact with WMI, itself it is not a function. _________________________ There are two types of vessels, submarines and targets.
Top

Page 1 of 1

1

Previous Topic

Previous Topic View All Topics

View All Topics

Index Next Topic

Next Topic

Moderator: Jochen, Allen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Arend_, Mart

Hop to:

Shout Box

Who's Online

1 registered (Allen) and 271 anonymous users online.

Newest Members

Sir_Barrington, batdk82, StuTheCoder, M_Moore, BeeEm
17886 Registered Users

Generated in 0.054 seconds in which 0.023 seconds were spent on a total of 12 queries. Zlib compression enabled.

click tracking