up vote 2 down vote favorite
share [g+] share [fb]

Is there any way to know who dropped a particular view from a database and at what time, may be using any system tables or so..please help?

Thanks

link|improve this question
5  
Social engineering. Send an email to everyone saying there's a prize to whoever made an excellent work with XYZ View. – Adrian Aug 11 '11 at 21:57
1  
This should really be on ServerFault.com. – David Stratton Aug 11 '11 at 22:02
4  
It was the person who's about to lose their permissions to drop views. – Catcall Aug 11 '11 at 22:24
1  
Sounds like a good name for a song... "Who dropped that view now? Who? Who? Who-Who?" – womble Aug 13 '11 at 7:40
feedback

migrated from stackoverflow.com Aug 12 '11 at 14:40

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 4 down vote

The default trace tracks DDL changes. I found an article detailing it here.

link|improve this answer
feedback
up vote 1 down vote

Every change is logged, including changes to schema.
You would have to examine the database logs using DBAdmin tools.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard