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

• What happens when a transaction fails on the publisher?
• In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?
• What can be used to ensure that a field in a table only accepts a certain range of values?
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?
• How can you easily monitor to see if this assembly is being used?
• Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database: Submitted by Charles Hawkins
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
• More...