Post reply

Service account

  • May 26, 2008 at 12:07 pm

    #186140

    Is it possible to dig out the sql server agent account name from system tables in SQL Server 2000(I don't want to use enterprise manager)? I have to tell my manager about sql server agent account being used on few servers.

    Manu

  • May 26, 2008 at 12:24 pm

    #820259

    its not in any system tables but it is held in the registry. Also could get it from the services applet.

    ---------------------------------------------------------------------

  • May 26, 2008 at 6:48 pm

    #820309

    You can make use of the below query and see if it helps,

    xp_regread @rootkey='HKEY_LOCAL_MACHINE',

    @key='SYSTEM\ControlSet001\Services\SQLServerAgent',

    @value_name='ObjectName'

    [font="Verdana"]- Deepak[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply