Return
-
Title
Spotlight using xp_regread -
Description
What is the xp_regread command used for ?
-
Resolution
The following scripts located in the <Quest Software>\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight folder use xp_regread command to get SQL Server Agent, services and SQL Mail details:
QS_JobAlerts.sql
QS_ServicesControl
QS_Services
QS_Services_SQLMail.sql