?
Solved

Unable to Kill Session

Posted on 2003-02-27
1
Medium Priority
?
426 Views
Last Modified: 2012-08-13
I have a SQL Server 7.0 SP6 with a remote link to a Sybase 12 database.

A stored procedure executes some Updates, Inserts and Deletes on the Sybase database by the link.

Sadly, the link was lost and so the SP did not finish. The process is still active in MS SQL:
Status:runnable
Wait Type:PAGEIOLATCH_SH
I cannot find the opposite process on Sybase so I believe that it was killed on that end.

But I cannot kill it on the MS SQL server with the GUI or the KILL statement.

And so the question is: how do I kill the process and free the resources it took on the MS SQL server.

Thanks in advance for your help.
0
Comment
Question by:sted
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 14

Accepted Solution

by:
adwiseman earned 400 total points
ID: 8034910
Re-start the server.  If you can't kill the process, that's your option.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

762 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