Domain.com as employed you as a database administrator. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database named Certkiller -DB06
Certkiller -DB06 consists of a trigger named trg_InsertOrders. The trigger fires when order data is inserted into the Orders table. The trigger ensures that a client exists in the Customers table prior to the information being inserted into the Orders table. You have received instruction from the CIO to configure the trigger to prevent it from firing during the information import process. You need to accomplish this using the minimum of administrative effort. Which Transact-SQL statements should you use? (Choose all that apply)
A.
You should use the statement sp_settriggerorder@triggername= ‘trg_InsertOrders’, @order=’None’.
B.
You should use the statement ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders Transact-SQL.
C.
You should use the statement ALTER TRIGGER trg_InsertOrders ON Orders NOT FOR REPLICATION Transact-SQL.
D.
You should use the statement DROP TRIGGER trg_InsertOrders Transact-SQL.
E.
You should use the statement DISABLE TRIGGER trg_InsertOrders ON Orders.
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 } [ ; ]