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?

219.

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?

Add your login name to the HR database role.

Qualify the trigger name with the trigger owner in the DROP TRIGGER statement.

Disable the trigger before executing the DROP TRIGGER statement

Define the trigger number in the DROP TRIGGER statement.

View Description

No description found.