Post reply

How can I see all changes done by a user/developr on a database

  • December 8, 2007 at 5:23 pm

    #93641

    Hi,

    I am wondering if there are any view/views that I can use to check all changes on a database e.g. a dba may want to see what kind of job (insert, update, delete, create a new table, trigger, procedure, function and which are the related tables) done by which user/developer daily basis.

    Thanks in advance,

    /Rana

  • December 8, 2007 at 5:58 pm

    #758337

    You may wish to set up triggers to log whatever level of detail you may need in a separate table.

    Of course, the transaction log itself will hold all of that information, but you are probably better off with triggers if you need to have the information well organized and archived.

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/

Viewing 2 posts - 1 through 1 (of 1 total)

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