question

Sagar Bhargava avatar image
Sagar Bhargava asked

xp_servicecontrol issue

Hi, I am trying to use the below query to check the status of the Analysis services on one of the SQL Server instance. This returns the state as Running, whereas under SQL Server Configuration Manager, I can see Analysis Services is disabled and Stopped. exec sys.xp_servicecontrol 'querystate', 'MSSQLServerOLAPService' HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerOLAPService -> Start Value is 4. Not sure where it is picking up value 'Running' from? Any info on this will be much appreciated :-) Thanks.
sql-server-serviceanalysis-services
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
David Wimbush avatar image
David Wimbush answered
It looks like that can happen: https://blogs.msdn.microsoft.com/mangeshd/2010/01/14/usage-of-xp_servicecontrol-is-unsupported/. The blog post suggests using WMI instead.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.