In this blog post, let’s learn about the error message “678 – Active rowset for partition ID %I64d found at the end of the batch. This error may indicate incorrect exception handling. Use the current activity window in SQL Server Management Studio or the Transact-SQL KILL statement to terminate the server process identifier (SPID) responsible for generating the error.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
678 – Active rowset for partition ID %I64d found at the end of the batch. This error may indicate incorrect exception handling. Use the current activity window in SQL Server Management Studio or the Transact-SQL KILL statement to terminate the server process identifier (SPID) responsible for generating the error.
Reason for the Error
To be update soon…
Solution
To be update soon…