Post reply

Is there a System table that tracks table changes globally?

  • July 21, 2008 at 7:02 am

    #189786

    Hi,

    Instead of writing a trigger that can track changes to tables, is there a system wide table that can track the changes for you just like you can to with Oracle 10g (flashback)?

  • July 21, 2008 at 11:52 am

    #845919

    There isn't such a table.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • July 21, 2008 at 11:54 am

    #845922

    Thanks. Just what I thought.

  • July 22, 2008 at 5:33 am

    #846292

    There is a way to get the query text of the executed query on the server. I think you can filter the information on UPDATE / INSERT basis.

    This article was posted yesterday or a day before yesterday.

    http://www.sqlservercentral.com/articles/SQL+Server+2000/63542/">

    http://www.sqlservercentral.com/articles/SQL+Server+2000/63542/

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply