024. SQL SERVER script to Find the Service Account Name

SQL Downloads, SQL SERVER, Sql Server Scripts
DECLARE @ServiceAccountName varchar(50)
EXECUTE master.dbo.xp_instance_regread
	N'HKEY_LOCAL_MACHINE'
	,N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER'
	,N'ObjectName'
	,@ServiceAccountName OUTPUT
	
SELECT @ServiceAccountName AS ServiceAccountName