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

  • r_saiyad

    Newbie

    Points: 9

    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

  • TimothyAWiseman

    SSCrazy Eights

    Points: 8819

    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 2 (of 2 total)

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