What objects were created, altered and deleted in the past 24 hours?

Part of knowing your server(s) and part of monitoring is to know what changes happened to the environment recently. In this sense, it would be a good idea to look into the default trace daily in order to see what changed in the system. The following script will give you a list of all objects which were created, altered and deleted in the past 24 hours. Of course, if the default trace is enabled.

Powered by Good Will. (Will is the person who offers his sympathy to others together with ideas, but who does not give any guarantee about the completeness of the concepts or the immaculate perfection of the scripts on this site. Use this site to grasp SQL Server concepts and to get knowledge. )