Posted on 2004-10-14
Medium Priority
Last Modified: 2012-06-21

I'm having 2 processed that have the Status KILLED/ROLLBACK, after a administrator killed these 2 sessions. The user aborted his application because it was taking to much time before it answered.
These connection where made over a OLEDB to a Oracle Database.

How can i clear/delete these 2 connections, because, even the oracle server is still reachable through the SQL server (in a select ....) the stored procedure that that application was calling/running is even in query analyzer not runnable. If you call that procedure the process hangs too.

Any idea/suggestion ??
Question by:HLEBOEUF
1 Comment
LVL 34

Accepted Solution

arbert earned 500 total points
ID: 12315338
You can't.  Unfortunately, there are some transactions that remain (ghost transactions) after they're killed.  They usually don't go away until you restart the server or the SQL Service.

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question