Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Australia
    Posts
    46

    Question Unanswered: Cant Kill Process

    Hi All,

    I have a table called Test1 on a MS SQL 7 Database. Wes ran an insert on the table however it is now locking the table, so we are unable to do anything with the table.

    We have tried to kill the process through both Enterprise Manager as well as Query Ananlyser however it still appears. If we try to drop the table it just sits there trying to complete this with no luck.

    Is there anyway possible to be able to kill this??

    Thanks
    Anthony

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    ROLLBACK can sometimes take hours. Try stop and restart MSSQLSERVER service.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •