You are the database developer for your company’s SQL Server 2000 database.
This database contains a table named Invoices. You are a member of the db_owner role. Eric, a member of the HR database role, created the Trey_Research_UpdateInvoices trigger on the Invoices table. Eric is out of the office, and the trigger is no longer needed. You execute the following statement in the Sales database to drop the trigger:
DROP TRIGGER Trey_Research_UpdateInvoices
You receive the following error message:
Cannot drop the trigger ‘Trey_Research_UpdateInvoices’, because it does not exist in the system catalog.
What should you do before you can drop the trigger?