How to get Service account information in SQL Server using scripts

select * from sys.dm_server_services

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-server-services-transact-sql?view=sql-server-ver15

EXEC master.dbo.xp_regread    'HKEY_LOCAL_MACHINE',
    'SYSTEM\CurrentControlSet\services\',    'ObjectName'
	

Other related Commands

EXECUTE master..xp_regremovemultistring
		@rootkey='HKEY_LOCAL_MACHINE',
		@key='SOFTWARETest',
		@value_name='TestValue',
		@value='Test'
xp_regwrite @rootkey='rootkey'
, @key='key'
, @value_name='value_name'
, @type='type'
, @value='value'
--type can be REG_SZ for string values or REG_DWORD for integers
--Beware, this will delete the whole key. Use Carefully.
xp_regdeletekey @rootkey='rootkey'
, @key='key'

Spread the love

Leave a Comment