I don't know exactly what happened, but I'm building an application in
ACC97 with a SQL 6.5 back end. In the middle of a transacted procedure an
error occured and the transaction was never rolled back. I can't say for
sure that this is where the problem started, but I suspect that it might
I have a bunch of INSERT processes running on my master database and a
bunch of object locks on my system tables. (eg tempdb.dbo.sysobjects,
tempdb.dbo.sysindexes, tempdb.dbo.syscolumns, tempdb.dbo.#info,
master.dbo.spt_values). Also Extent Lock - Exclusive for 3 identical items
sa.master.dbo/INSERT/ServerName (MS SQLEW) (when I click detail it says
I tried to Kill it with the GUI interface, I tried the Kill command in
T-SQL, I bounced the SQL Server, the NT Server, and every machine connected
to my SQL Server. These processes will not die and it is preventing me
from running the code where the problem started.
Any ideas, this is very frustrating.