Professional Web Applications Themes

Find out the commands executed - Microsoft SQL / MS SQL Server

We have a stores database on SQL Server 2000. What I need to know is the exact changes (or what ever the sql commands that are executed) during a specific interval of time on the StoreDatabase. e.g. between 10:15 AM and 10:30 AM. Is there anyway I could do that? Thanks for helping! db...

  1. #1

    Default Find out the commands executed

    We have a stores database on SQL Server 2000. What I need to know is
    the exact changes (or what ever the sql commands that are executed)
    during a specific interval of time on the StoreDatabase.
    e.g. between 10:15 AM and 10:30 AM.

    Is there anyway I could do that?

    Thanks for helping!

    db
    Dan Guest

  2. #2

    Default Re: Find out the commands executed

    Use can use the SQL Server Profiler to capture the sql commands against a
    given database.

    regards, -marty nicholson

    "Dan" <com> wrote in message
    news:google.com... 


    Martin Guest

  3. #3

    Default Re: Find out the commands executed

    As already suggested Profiler or a server side trace could be used if you
    are interested in future events, if you want to have a look at what happened
    in the past then the only tool really available would be Log Explorer from
    www.lumigent.com

    --
    HTH

    Jasper Smith (SQL Server MVP)

    I support PASS - the definitive, global
    community for SQL Server professionals -
    http://www.sqlpass.org

    "Dan" <com> wrote in message
    news:google.com...
    We have a stores database on SQL Server 2000. What I need to know is
    the exact changes (or what ever the sql commands that are executed)
    during a specific interval of time on the StoreDatabase.
    e.g. between 10:15 AM and 10:30 AM.

    Is there anyway I could do that?

    Thanks for helping!

    db


    Jasper Guest

Similar Threads

  1. Can a .as be executed in CF8
    By -==cfSearching==- in forum Coldfusion Flash Integration
    Replies: 5
    Last Post: December 19th, 04:23 AM
  2. commands to find types of raid
    By yls177 in forum Linux / Unix Administration
    Replies: 2
    Last Post: September 15th, 02:29 AM
  3. To find the model of a server through commands.
    By yls177 in forum Linux / Unix Administration
    Replies: 3
    Last Post: August 30th, 09:35 AM
  4. ASPX not executed
    By taja in forum ASP
    Replies: 1
    Last Post: October 22nd, 02:45 AM
  5. What's the command to find the name of the file being executed?
    By Scott E Robinson in forum PERL Beginners
    Replies: 1
    Last Post: September 3rd, 09:47 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139