Which four Transact-SQL statements should you use?

DRAG DROP

You administer a Microsoft SQL Server database server that has a database named Contoso. The Contoso database has a table named EmployeeSalary in a schema named HumanResources.

You need to create a script that writes audit events into the application log whenever data in the EmployeeSalary table is modified by the public principal.

Which four Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)

View Answer

Answer:

Explanation:

References: http://msdn.microsoft.com/en-us/library/cc280386.aspx http://msdn.microsoft.com/en-us/library/cc280448.aspx http://msdn.microsoft.com/en-us/library/cc280404.aspx