Correct Answer: Use triggers or use change data capture (CDC)
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Microsoft SQL Server Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Microsoft SQL Server MCQ Questions
TRUE OR FALSE: Is it possible to execute a Stored Procedure in a UDF.
Which of the following best describes the flow for the execution of a CLR stored procedure?
Which versions of SQL Server support table partitioning?
Which of the following relationships requires a reference table?
True or false? Intersection tables should have an autoincrement column as the primary index
Which among the following are the new datatypes introduced in the SQL Server 2005?
You have a database named 'marketnikkie', the backup of which is stored at 'D:\marketnikkie.bak' location on your server. Due to some electric fluctuations, the database gets corrupt. Which of the following is the correct query to restore your database?
Which clause will be used to extract data from Tables A and B having a similar structure but no relation between themselves?
Which of the following is not a type of Database backup in the SQL SERVER 2005?
State whether True or False. The 'text' and 'ntext' data type can store character based data. These data types can be used in joins