Note: This question is part of a series of

questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.

You have a database that contains a table named Employees. The table stores information about the empl

oyees of your company.

You need to implement the following auditing rules for the Employees table:

Record any changes that are made to the data in the Employees table.

Customize the data recorded by the audit operations.

Solution: You implement a check c

onstraint on the Employees table.

Does the solution meet the goal?

A. Yes

B. No

Explanation:

Check constraints cannot be used to track changes in a table.

References: https://msdn.microsoft.com/en-us/library/bb933994.aspx