Identify dropped objects from SQL Server
I wanted to figure out if there's a way through which we can identify if any object such as storedprocedure, table, view, trigger etc has been dropped from sql server 2k. are there any logging information which can give me the input or is there any third party tools that'll help me identify the drop.
recently i faced this issue in my development environment where my code was referencing an SP and the next day the code broke informing the SP doesn't exit. i had to restore from the backup i had, but was not able to figure out who or how was the sp dropped.
I hope i made myself clear on this regard. Would appreciate replies.