Find who/when a SQL view is dropped in SQL Server
<p>In one of our SQL Server databases we have many SQL views. One particular view keeps disappearing every few weeks, and I want to find out what is happening.</p>

<p>Is there a way to query SQL Server to find out when and who dropped the view? </p>

<p>Alternatively, is it possible to add a SQL Server trigger on the <code>DROP</code> view command to capture and fail the <code>DROP</code>?</p>