Correct Answer: Rolls back to the start of the outer transaction
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
With automatic conflict resolution in peer-to-peer replication, which update wins the conflict?
How is FILESTREAM data stored?
What is the benefit of using the TRY_CAST() function?
Which system database holds information on SQL Server Agent jobs?
Which data extents are backed up by a differential database backup?
Which of the following roles is required to connect to a Central Management Server?
Which of the following clauses of SQL Server 2008 avoids enforcing a constraint when repeated inserts are performed?
Analyze the following code snippet: DECLARE @myDate DATETIME2 SELECT @myDate = '2009/10/08 12:35:29.2348 +12:15' SELECT @myDate AS '@myDate' What is the output of the above code?
Which of the following stored procedures is used to delete data from the management data warehouse of a Data Collector?
Which of the following is the default authentication mode for sqlcmd in SQL Server 2008?