开发者

Transaction Locked Down SQL Server 2005

I have noticed something over the last few months. Each time we run a script that has a tra开发者_StackOverflow中文版nsaction statements let say we stop the query unexpectedly this action actually lock the database.

The only way out is to destroy the transaction each time. I have never experience this before even though I have stopped the query in the middle of transaction in the past and it has never locked the database.

Could it be that we are missing something in settings or I should not stop transaction queries unexpectedly?

The problem occurred with SQL SERVER 2005. please I need your brain. Thanks Guys


This is usual: you have sent a client abort which say "stop processing"

To rollback and release lock, you need to use SET XACT_ABORT ON

SO 1 and SO 2

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜