Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: View queries... out of Log?

    I need to see all the queries done on an Database.
    How to do?

    Sorry if this question is a bit stupid, but i am just an MSSQl beginer.

    Thanks for any help.

    Best regards.... Josef

  2. #2
    Join Date
    Aug 2003
    Posts
    2

    .... add

    got mssql server version 8

  3. #3
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    You can use SQL profiler and audit the SQL:Batchcompleted statements. You can store these in a table and save them (be careful and mindful of db growth)

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  4. #4
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117

    Re: View queries... out of Log?

    You can use SQL Profiler.(use a template or create your own trace). Of course this is only for future queries. For older queries you can use Lumigent's log viewer (which is not free ... :'(

    Originally posted by spacefrog
    I need to see all the queries done on an Database.
    How to do?

    Sorry if this question is a bit stupid, but i am just an MSSQl beginer.

    Thanks for any help.

    Best regards.... Josef
    Steve

Posting Permissions

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