Hi this is my first post on sql....
The below procedure will check the current errorlog(past one hour errorlog will be scanned)for the keyword "error" (you can include your own key word) ..
If you run the procedure it will look for keyword error in the past one hour... it will be use full for some critical server who needs to monitor it frequently..
Your suggestions are mostly welcomed.
First the SP_TABLECOMPARE was used from the site and all credit must go to the author (greate script). This script is for the creation of an audit trial. It is generic and can be used on any sql database. It deals with legasy naming conventions as well. The script creates the audit tables and triggers. […]