Post reply

ProgramName Details

  • June 11, 2008 at 4:40 pm

    #124352

    SP_WHO2 and several other tools will tell you the ProgramName of a spid. However the result is very vague. For example, if an Office application has opened the connection then the ProgramName simply says "Microsoft Office 2003". What I am after is the actual file name that opened the connection. We have a large number of Access applications and I need to know which one is opening which connections. In reality I would like to know the name of the query that is reading the database, but that is probably not possible.

  • June 11, 2008 at 4:46 pm

    #827589

    This value is passed in the connection string as ApplicationName. If you want to uniquely identify connections, you'll have to have them identify themselves in the connection string.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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