Wednesday, April 11, 2012

SQL Query to find out Service Account details


DECLARE @ServiceaccountName varchar(250) 


EXECUTE master.dbo.xp_instance_regread 
N'HKEY_LOCAL_MACHINE', 
N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER', 
N'ObjectName', 
@ServiceAccountName OUTPUT, 
N'no_output'
  
SELECT @ServiceaccountName