Which four Transact-SQL statements should you use?

DRAG DROP

You administer a Microsoft SQL Server 2012 server that has a database named Contoso. The Contoso database has a table named ProductPrices in a schema named Sales.

You need to create a script that writes audit events into the application log whenever data in the ProductPrices table is updated.

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