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?
A. Execute the following Transact-SQL statement: EXECUTE sp_KillSPID 64
B. Restart the SQL Server service.
C. Execute the following Transact-SQL statement: KILL 64
D. Execute the following Transact-SQL statement: ALTER SESSION KILL '64'
You administer a Microsoft SQL Server 2012 instance. You need to stop a blocking process that has an SPID of 64 without
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You administer a Microsoft SQL Server 2012 instance. You need to stop a blocking process that has an SPID of 64 without
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!