Logging DDL

  • I wnat to be able to Log DDL Operation On A database

    Manly Droping of an object

    Can it Be done an Who

    My Problem is that I have A magic Free Lancer programer (Friend of CEO) that one of his sevral thousend programs is dropping and creating a table on the fly

    He did not find wich one and we are loosing data every now and than.

    He is the database whoner and I can not prevent from him the drop and creation of objects

  • Use SQL Profiler. Trace the object:deleted event and possibly some filtering so you can just isolate this one login.

    Cheers,

    - Mark


    Cheers,
    - Mark

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

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