i want to ask about how i can send notification e-mail message when Approve Leave in sql server 2005 to know this Hi Dear (EmployeeName) Your Leave Approved.. .