Post reply

Track Databases

  • November 17, 2010 at 7:23 am

    #241252

    Hi All,

    I am working in critical 24 x 7 application in sql server. we are in a need of tool, to track the changes that are applied to the table between two dates with the script that is used to change the table. tool should track prod,acc and dev servers. is there any solution for that?. creating triggers might degrade the performance.? any feasible solution without disturbing the servers..

    Thanks

  • November 17, 2010 at 9:18 am

    #1251954

    Take a look at this article http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx

    This provides some of what you're looking for, while at the same time minimizing overhead. Otherwise, to get the level of detail you may be looking for, you will be looking at using C2 audit tracing which can be a beast.

    😀

  • November 17, 2010 at 11:23 am

    #1252047

    You can also try Change Data Capture (CDC) feature in SQL Server 2008. More here

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 17, 2010 at 11:52 am

    #1252082

    There's also something called change tracking, which isn't as detailed as CDC, you can read about it here

    Hope this helps,
    Rich

    [p]
    [/p]

  • November 18, 2010 at 1:19 am

    #1252307

    Hi All,

    Happy with your ideas. I need to track the structural change of the table.

    i.e. Alter table.

    CDC will be a overhead if frequent changes occurs but that doesnt track DDL changes.

    Thanks,

    vino

  • November 18, 2010 at 1:22 am

    #1252309

    You can make use of the Default Trace to track DDL Changes. Please go through this[/url] useful article on SSC.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 6 posts - 1 through 5 (of 5 total)

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