You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.
The customer service representatives in your company add and edit the information in the complaints table. They work with this table by using a number of client applications, including a web-based application and a Microsoft Windows 32-bit application.
The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.
You need to notify the customer service manager whenever a complaint is marked as closed. You do not want to make any changes to the client applications.
What should you do?
A．Create an UPDATE trigger that sends an e-mail message.
B．Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
C．Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
D．Create a rule that validates data entry. Bind the rule to the CompliantClosed column.