You are work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB06.
Certkiller -DB06 hosts a database that contains a trigger named trg_InsertOrders. The trigger, trg_InsertOrders is configured to fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You want to use the minimum amount of administrative effort to configure the trigger to prevent it from firing during the data import process? Which of the following Transact-SQL statements can be used? (Each answer presents a complete solution. Choose TWO.)
A.
ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders
B.
DROP TRIGGER trg_InsertOrders
C.
DISABLE TRIGGER trg_InsertOrders ON Orders
D.
ALTER TRIGGER trg_InsertOrders ON Orders NOT FOR REPLICATION
E.
sp_settriggerorder@triggername= ‘trg_InsertOrders’, @order=’None’
Explanation:
You do not want to alter or delete the trigger, so that you can use the trigger again with the least administrative effort. You should use the DISABLE TRIGGER Transact-SQL command.
Syntax:
DISABLE TRIGGER { [ schema . ] trigger_name [ ,…n ] | ALL } ON { object_name | DATABASE | ALL SERVER } [ ; ]