In MS SQL Server 6.5 how do you kill a process where a user is running a select statement from MS Access. When I try to kill it by going to "Current Activity", selecting the process then selecting "Kill Process" it does not work.
OK. I was hoping that there was some system command (like the "kill -9" command in unix) I could use when this happens. One of our users runs reports from an Access connection and every now and then he will lock up the other 50 or so users.
T-SQL has a kill command. Enterprise Manager uses the kill command when you select "kill process." You can try kill in the query analyzer. Execute "kill spid" wher spid is the "system process ID" of the offending run. Terry
;-) I never worry about the future. It comes soon enough. -Albert Einstein
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.