DBA > Job Interview Questions > Microsoft SQL Server FAQs

You want to disable the trigger dEmployee on the

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You want to disable the trigger dEmployee on the HumanResources...

You want to disable the trigger dEmployee on the HumanResources.Employee table in the SQL Server 2005 AdventureWorks sample database. Which of the following statements will do the trick?


Answer
A and B

Explanation
Either of the commands in A and B will disable the trigger.

(Continued on next question...)

Other Job Interview Questions