Professional Web Applications Themes

Tracking Changes to Records - Microsoft SQL / MS SQL Server

There are quite a few third party tools for this. e.g. [url]http://www.lumigent.com[/url] There's a tool called Entegra which allows you to audit without triggers. -- Regards, Mandar Naik This posting is provided AS IS with no warranties, and confers no rights. "Andy Driskell" <andydnowhereman.com> wrote in message news:#yGC#XwPDHA.1612TK2MSFTNGP11.phx.gbl... > Hi all, wasn't sure where to post this so decided to try here first of all. > > What I am trying to do is to see what changes are being made to records in a > certain database by a program being run on a client that updates data. The ...

  1. #1

    Default Re: Tracking Changes to Records

    There are quite a few third party tools for this. e.g.
    [url]http://www.lumigent.com[/url]

    There's a tool called Entegra which allows you to audit without triggers.

    --
    Regards,
    Mandar Naik


    This posting is provided AS IS with no warranties, and confers no rights.
    "Andy Driskell" <andydnowhereman.com> wrote in message
    news:#yGC#XwPDHA.1612TK2MSFTNGP11.phx.gbl...
    > Hi all, wasn't sure where to post this so decided to try here first of
    all.
    >
    > What I am trying to do is to see what changes are being made to records in
    a
    > certain database by a program being run on a client that updates data.
    The
    > SQL server is version 7.0 and I have been trying to use Profiler to do
    this
    > with no joy so far. I dont fancy setting up triggers to track the changes
    > as there is over 100 or so tables in the database.
    >
    > Can anyone point me in the right direction for doing this sort of thing?
    >
    > Thanks in advance,
    >
    > Andy D
    >
    >

    Mandar Naik[MSFT] Guest

  2. #2

    Default Re: Tracking Changes to Records

    You can use a tool such as profiler but it can be bersome or imposable to
    find what your after and it has some performance and maintenance down sides
    that you have to deal with. You can use triggers but again they have
    downsides that you may not want to deal with. There are some 3rd party
    tools such as [url]www.redmatrix.com[/url] that can help to create the triggers. But
    the tool from lumigent will give you the most features in the least amount
    of time in a very well thought out interface. While it may seem like a lot
    of money it will save you much more than that in time you won't have to
    spend dealing with the alternatives.

    --

    Andrew J. Kelly
    SQL Server MVP


    "Andy Driskell" <andydnowhereman.com> wrote in message
    news:ecOdipwPDHA.1216TK2MSFTNGP11.phx.gbl...
    > I have stumbled onto that site already today, is there no other way to do
    > this than with a third party tool? or is it database triggers all the
    way?
    >
    > Cheers,
    >
    > Andy D
    >
    > "Andrew J. Kelly" <sqlmvpnooospamshadhawk.com> wrote in message
    > news:%23BVKfhwPDHA.2256TK2MSFTNGP11.phx.gbl...
    > > The best tool for the job is from [url]www.lumigent.com[/url]
    > >
    > >
    > > --
    > >
    > > Andrew J. Kelly
    > > SQL Server MVP
    > >
    > >
    > > "Andy Driskell" <andydnowhereman.com> wrote in message
    > > news:%23yGC%23XwPDHA.1612TK2MSFTNGP11.phx.gbl...
    > > > Hi all, wasn't sure where to post this so decided to try here first
    of
    > > all.
    > > >
    > > > What I am trying to do is to see what changes are being made to
    records
    > in
    > > a
    > > > certain database by a program being run on a client that updates data.
    > > The
    > > > SQL server is version 7.0 and I have been trying to use Profiler to do
    > > this
    > > > with no joy so far. I dont fancy setting up triggers to track the
    > changes
    > > > as there is over 100 or so tables in the database.
    > > >
    > > > Can anyone point me in the right direction for doing this sort of
    thing?
    > > >
    > > > Thanks in advance,
    > > >
    > > > Andy D
    > > >
    > > >
    > >
    > >
    >
    >

    Andrew J. Kelly Guest

Similar Threads

  1. Ad Tracking
    By coldpopper in forum Macromedia Flash Ad Development
    Replies: 2
    Last Post: February 13th, 02:57 AM
  2. InDesign tracking vs. Quark tracking?
    By Mike Witherell in forum Adobe Indesign Macintosh
    Replies: 0
    Last Post: July 15th, 10:23 PM
  3. Tracking IP
    By Seth in forum ASP.NET Web Services
    Replies: 3
    Last Post: March 4th, 12:50 PM
  4. tracking a pid
    By mike in forum Sun Solaris
    Replies: 2
    Last Post: July 27th, 08:33 PM
  5. Tracking changes for web app
    By Adrian Walters in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 9th, 08:21 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