Microsoft
70-457 · Question #170
You administer a Microsoft SQL Server 2012 instance. You need to stop a blocking process that has an SPID of 64 without stopping other processes. What should you do?
The correct answer is C. Execute the following Transact-SQL statement. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2012 instance. You need to stop a blocking process that has an SPID of 64 without stopping other processes. What should you do?
Options
- AExecute the following Transact-SQL statement:
- BRestart the SQL Server service.
- CExecute the following Transact-SQL statement:
- DExecute the following Transact-SQL statement:
How the community answered
(28 responses)- A18% (5)
- B4% (1)
- C71% (20)
- D7% (2)
Community Discussion
No community discussion yet for this question.