Tag: Service Account
-
T-SQL Script to Return the Service Accounts of SQL Server and SQL Agent Services
/* This script reads out the names of sql server service account and sql server agent service account Author:Ning Xu Date: 2010-09-16 Applied version: 2000, 2005, 2008 */ DECLARE @serviceaccount as varchar(50) EXECUTE master.dbo.xp_instance_regread N’HKEY_LOCAL_MACHINE’, N’SYSTEM\CurrentControlSet\Services\MSSQLSERVER’, N’ObjectName’, @serviceAccount OUTPUT, N’no_output’ SELECT @Serviceaccount as SQLServer_ServiceAccount EXECUTE master.dbo.xp_instance_regread N’HKEY_LOCAL_MACHINE’, N’SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT’, N’ObjectName’, @serviceAccount OUTPUT, N’no_output’ SELECT @serviceaccount as…