You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. The tables in the CK_Sales database are shown in the following database diagram.

Several products listed in the Products table have been discontinued. You want to delete the data from the Products table that refer to the discontinued products. You also want to copy data from the Invoices table that are related to the discontinued products to a separate table named DiscontinuedProductInvoices. You decide to use triggers to accomplish this task. The first trigger will delete rows from the Products table while the second trigger will to copy data from the Invoices table to the DiscontinuedProductInvoices table. You want the second trigger to execute once the first trigger is executed.
exhibit What should you do?