Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    1

    Unanswered: Advantage Database Server: query tracking

    I'm looking for a way to find out the time each query in ADS executes, from which computer, and from which application. Is there a way to do this?
    Last edited by dhinge; 09-24-08 at 12:23.

  2. #2
    Join Date
    Oct 2008
    Posts
    1
    Check out sp_EnableQueryLogging and sp_DisableQueryLogging. If you don't need a persistent log, you can also see queries in the remote management functionality in Advantage Data Architect.

    The help file page for sp_EnableQueryLogging can be found here:

    http://devzone.advantagedatabase.com...erylogging.htm

    J.D. Mullin
    Advantage R&D
    http://jdmullin.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •