Professional Web Applications Themes

Logging changes in a table! - Microsoft SQL / MS SQL Server

Hello! How can I use ADO in VC++ to log changes in a database? Not the structure, but INSERT / UPDATE/ DELETE? I was thinking of creating another Database to log these tables, but not shure where to start. Using SQL2k and VC6.0 - Lars...

  1. #1

    Default Logging changes in a table!

    Hello!

    How can I use ADO in VC++ to log changes in a database? Not the structure,
    but INSERT / UPDATE/ DELETE?

    I was thinking of creating another Database to log these tables, but not
    shure where to start.

    Using SQL2k and VC6.0


    - Lars


    Lars Guest

  2. #2

    Default Re: Logging changes in a table!

    Lars Grøtteland wrote: 
    You don't need any external C++ code for this. Just create a table that
    contains the columns you wish to track along with a DateModified column, and
    then create a trigger on the source table that logs the changes to the audit
    table. If you do a Google Groups search on the keywords sql and trigger and
    audit you should find plenty of examples

    Bob Barrows


    Bob Guest

  3. #3

    Default Re: Logging changes in a table!

    Is this the smartest way of doing it?

    Hasn't anyone done this in code?

    - Lars
    "Bob Barrows" <com> wrote in message
    news:uW7%phx.gbl... 
    > You don't need any external C++ code for this. Just create a table that
    > contains the columns you wish to track along with a DateModified column,[/ref]
    and 
    audit 
    and 


    Lars Guest

Similar Threads

  1. Fw: Turn off logging for a single table [1871]
    By Mark Denham in forum Informix
    Replies: 0
    Last Post: September 15th, 12:42 PM
  2. Replies: 0
    Last Post: September 10th, 10:49 PM
  3. Replies: 0
    Last Post: September 10th, 05:33 PM
  4. Replies: 2
    Last Post: August 12th, 07:55 AM
  5. Truncate table logging
    By FR in forum Microsoft SQL / MS SQL Server
    Replies: 6
    Last Post: July 20th, 07:38 AM

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