Post reply

Keeping track on changes in SQL SErver

  • January 7, 2009 at 10:27 am

    #77169

    How can I check who added or removed field in the table.Thank you

  • January 7, 2009 at 10:50 am

    #922737

    in SQL 2000, after the fact, most likely you cannot find out.

    if you had profiler running a trace, you can go to the profile....but unless you set it up and it was running before hand, that's not possible.

    the last alternative is if the database in question is set to FULL Recoevery model instead of SIMPLE, you can use a 3rd party log Reader like Red Gate's SQL Log Rescue or the one from Lumigent.

    If the recover model is NOT Full, it is impossible to determine who did anything.

    in SQL 2005 you have more options. There is a "default" trace that is always running, and you can add auditing triggers for DDL changes, where a objects in the db(procs/functions.views/tables) are created/altered/dropped.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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