(DIR) Return Create A Forum - Home --------------------------------------------------------- ExcelSoft Database Professionals (HTM) https://esdbp.createaforum.com --------------------------------------------------------- ***************************************************** (DIR) Return to: Scripts ***************************************************** #Post#: 11-------------------------------------------------- Run Diagnostic information on server By: srinivasma_exceldbp Date: February 27, 2014, 12:24 am --------------------------------------------------------- Usage : exec sp_lib_diagnostics_00 0,0 exec sp_lib_diagnostics_00 1,1 -- Check Object, Check SPs Explanation of priority levels: 1 - Critical risk of data loss. Fix this ASAP. 10 - Security risk. 20 - Security risk due to unusual configuration, but requires more research. 50 - Reliability risk. 60 - Reliability risk due to unusual configuration, but requires more research. 100 - Performance risk. 110 - Performance risk due to unusual configuration, but requires more research. 200 - Informational. #Post#: 148-------------------------------------------------- Re: Run Diagnostic information on server By: Yasub_exceldbp Date: April 14, 2015, 6:29 am --------------------------------------------------------- Sir, Wonderful script! Thank you! Can you please point me to the source of this script? -Yasub *****************************************************