Prev: Stored Procedure details in one query
Next: MSDTC - SQL server 2008 - Windows Server 2008 R2 Standard
From: Joachim Hofmann on 9 Jun 2010 05:07
Hello,

I would like to get the name of the SQL Server Agent Account by a (SQL) - Query,
or, to ask otherwise, if a given login comes from the SQL Server Agent.

Thank You

Joachim
From: Uri Dimant on 9 Jun 2010 06:29
DECLARE @serviceaccount varchar(100)

EXECUTE master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',

N'ObjectName',

@ServiceAccount OUTPUT,

N'no_output'

SELECT @Serviceaccount





"Joachim Hofmann" <speicher(a)freenet.de> wrote in message
news:ejIRmM7BLHA.4308(a)TK2MSFTNGP04.phx.gbl...
> Hello,
>
> I would like to get the name of the SQL Server Agent Account by a (SQL) -
> Query,
> or, to ask otherwise, if a given login comes from the SQL Server Agent.
>
> Thank You
>
> Joachim


 | 
Pages: 1
Prev: Stored Procedure details in one query
Next: MSDTC - SQL server 2008 - Windows Server 2008 R2 Standard