Post reply

SQLServer Service account name from Query Analyzer

  • March 12, 2007 at 4:49 am

    #69876

    Hi Dudes,

    Do we have any system functions/extended stored procedure/dbcc commands to get the service account name(MSSQLServer/SQLServerAgent) from the Query analyzer.We are using SA login and we are accessing the server from the remote.

    Thanks in advance

    Regards

    Marimuthu

  • March 12, 2007 at 10:01 am

    #694426

    You could use xp_regread or if it's a named instance xp_instance_regread. But be carefull using them, since they are undocumented procedures and act slightly different for 2005.

    Markus

    [font="Verdana"]Markus Bohse[/font]

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

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