Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

Thanks.

share|improve this question

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

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

3  
(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

1 Answer 1

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.