{[['
']]}
![](http://static.graddit.com/img/star.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5ZpieVHXYmzOkT4sSXvVh65DWA7SYxYgehVjgoNvHZtthBV9UhP1D-zvuXtJBXmpg9L7VlQLDOc2-7COhi-VGpS9NvbexWBBiCjIlVFHM-bhoKy_xzXrZJSsh990cCmOowCZM1NdiYYw/s1600/SQL-LOGO.png)
Database Monitoring
Find the changes made using Data Definition Language (DDL)Right click on Server Icon and go to Reports > Standard Reports > Schema Changed History. This Reports output would changed based on where you right clicked it (on server icon or database name)![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg96W87M6MW_oqlkS0d7JFQYnx6bbmBQCgoBDSnBId3PxohWGhAd7_jW8PGZy_UZ_UkGnvxw35jnfFTO9I2CAThg7pAaBd-bmsiTCed40wrWdqeFSloK9k8leaFNpkhelQwvoj3FFGyoI4/s1600/0.png)
Who do what ?, when did he do it ?, someone deleted database objects, tables, procedures,
Track ... Historical changes over time.
Enjoy!!!
Post a Comment