Get Service account details using TSQL:
DECLARE @sn NVARCHAR(128);
EXEC master.dbo.xp_regread...
'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\services\MSSQLSERVEr',
'ObjectName',
@sn OUTPUT;
SELECT @sn;
DECLARE @sn NVARCHAR(128);
EXEC master.dbo.xp_regread...
'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\services\MSSQLSERVEr',
'ObjectName',
@sn OUTPUT;
SELECT @sn;
Get SQL Service Agent account details using TSQL:
DECLARE @sn NVARCHAR(128);
EXEC master.dbo.xp_regread...
'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\services\SQLSERVERAGENT',
'ObjectName',
@sn OUTPUT;
SELECT @sn;
DECLARE @sn NVARCHAR(128);
EXEC master.dbo.xp_regread...
'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\services\SQLSERVERAGENT',
'ObjectName',
@sn OUTPUT;
SELECT @sn;
The Certified Business Analysis Professional (CBAP) credential validates your advanced skills in business analysis, requirements management, and solution assessment. Earn recognition as an expert BA to accelerate your career growth.
ReplyDelete