<div>
You can restore your latest backup + transaction logs onto another DB and see whether the table is there.<br />
Generally, unless you have auditing turned on, there is no way (that I am familiar with) of telling when the table was dropped.
</div>


You can restore your latest backup + transaction logs onto another DB and see whether the table is there.
Generally, unless you have auditing turned on, there is no way (that I am familiar with) of telling when the table was dropped.

<div>
how would you know if auditing is turned on?
</div>


how would you know if auditing is turned on?

<div>
and how would you restore the transaction logs?
</div>


and how would you restore the transaction logs?

<div>
Gimme a sec... looking for the script that does that...
</div>


Gimme a sec... looking for the script that does that...

<div>
<div class="content wysiwyg-content">
I have a missing table in the database, I would like to know if I can see when it was deleted. How can I view transaction log? Is there any way to recreate it, roll back the transaction?<br />
<br />
thanks
</div>
</div>


I have a missing table in the database, I would like to know if I can see when it was deleted. How can I view transaction log? Is there any way to recreate it, roll back the transaction?

thanks

Missing Table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.