You want to disable the existing trigger named Sales.Order_Count that applies to the Sales table. You might need to re-enable this trigger in the future.

Which of the following Transact-SQL statements can you use to accomplish this goal?

 Posted by Rajkatie on 11/30/2012 | Category: Sql Server Interview questions | Views: 3577 | Points: 40
Select from following answers:
  1. DISABLE TRIGGER Sales.Order_Count ON Sales
  2. ALTER TRIGGER Sales.Order_Count ON Sales
  3. ENABLE TRIGGER Sales.Order_Count ON Sales
  4. All Above

Show Correct Answer


Source: Measureup.com | | Alert Moderator 

Comments or Responses

Login to post response