PrepAway - Latest Free Exam Questions & Answers

Tag: kill sql server session and transaction

What are two possible ways to achieve this goal?

Domain.com uses SQL Server 2005. A user reports that an order processing application stopped responding during a transaction. You investigate and discover that the user’s session, which is session ID 85, is being blocked by an errant process. The session ID of the errant process is 101. You need to solve this blocking situation quickly so that the user can continue using the application without losing any work. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)