Hi All if anyone knows how to use net send to send a message to DBA if an alert fired? for example: hardware fails with severity level 24. we want to know it but we don't use sqlagentmail function on sql server 2000. or is there any way to notify DBA? any idea will be very appreciated. thanks, Long
Referhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=15583 and it seems both the questions are from same person. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
Hi, refer answer http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=15586 and refer * sp_add_alert * in BOL for more. * donot post duplicate questions. Regards Hemantgiri S. Goswami ghemant@gmail.com "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami