Your best bet is to use a seperate identity column to increment.

You can alter your table as follows:

alter table

 my_table

add

 my_idcol numeric identity(1,1)

go

If you apply this to the table it will add...

In similar situations I've found that

BACKUP LOG mydb WITH NO_LOG or WITH TRUNCATE_ONLY

Works very satisfactorily

I had the same problem a while ago on our system with a spid that wouldn't die.

Turned out it was the result of an aborted operation.

The only way to kill...