Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
Determining how a schema change occurred?

Using SQLServer 2008, I see in my schema a particular table was dropped. I am trying to figure out when / why etc? Is there any commands I can run to see when the table was dropped, or anything that could help me out.


share|improve this question

marked as duplicate by Martin Smith, Marian, Mark Storey-Smith, JNK, gbn Feb 16 '12 at 14:50

This question was marked as an exact duplicate of an existing question.

(Of course the question itself is slightly different but the answers there apply to this schema change too) – Martin Smith Feb 16 '12 at 12:44
Yep. Default trace is the answer. – Grant Fritchey Feb 16 '12 at 14:18

Postfactum you not available to see it

If you want to know this in the future - see all about DDL Triggers

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.