possible to see who deleted a tabel column

  • Is there a way to see who was responsible for deleting a column in a table? I had a sproc which worked fine then would give an error stating that the columns in an insert in a sproc didn't match the destination. Then I retried the Alter command and it was successful.

  • If you have a trace running that captures that kind of thing, it's pretty easy to find out.

    If you have a DDL log, again, it's easy to find out.

    If you have a log parser (like from ApexSQL or Lumigent), it's not easy to find out, but it's possible.

    Otherwise, not really.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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