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
AnthonyROLLBACK can sometimes take hours. Try stop and restart MSSQLSERVER service.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment