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

  • 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

  • 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