I'm looking for some TSQL scripts to check the health of a system after a deployment.
So we have one system that is heavy dependant on other databases. Often when someone makes a changes or a deployment to those systems, it breaks this system. I want to check have user/application permissions changes, have SP changed or are missing, same with views. Things like lookup, and data missing I can script ok. Its the where database objects themselves have been altered I don't know how to check in a script. The admin stuff. I can do it manually. But I want to automate it.
For example one time someone renamed the database and it took a while to realise this was the problem. Another time someone replicated live back to dev and lost all the Stored Procs that were in dev but not live. Sometimes they remove data which breaks the system.
I just don't want to have spend so much time finding out what happened.
Even links to where I can research this.
So we have one system that is heavy dependant on other databases. Often when someone makes a changes or a deployment to those systems, it breaks this system. I want to check have user/application permissions changes, have SP changed or are missing, same with views. Things like lookup, and data missing I can script ok. Its the where database objects themselves have been altered I don't know how to check in a script. The admin stuff. I can do it manually. But I want to automate it.
For example one time someone renamed the database and it took a while to realise this was the problem. Another time someone replicated live back to dev and lost all the Stored Procs that were in dev but not live. Sometimes they remove data which breaks the system.
I just don't want to have spend so much time finding out what happened.
Even links to where I can research this.
