Hi, i´m working on sql server 2005, monitoring a data base. I have the following task: to create an alarm system by mail, of events like process that take more than 3 seg and the sql server profiler detects.I´m saving the monitoring data in a table of the data base. I also have a trigger that sends the email.The issue ocurrs when the trace starts, and it seems that all the triggers are deleted, all that are related to the table where i save the data of the trace. If I create the trigger while the trace is working, it stops and sends an error.what do you recommend to do?
Iam not great fan of SQL profiler , would prefer to run the script as maintainence task and if it fails would send a email alert to operator. Please try the maintainence wizard in SQL 2005 and write a query for same as SQL script , schedule a task and mention during failure to send email. You would require outlook mail client installed on server to get mail out.