Sql Server 2000
I was running a test on an SP with a Begin Transaction to insert 2 rows into
a table from another table which only contains 2 rows. But I forgot to
include a commit transaction (actually there was a commit tran... about 100
lines down but I commented it out and forgot to include it in the test
portion of the SP). Now I can't delete the table or even drop it -- from
query analyzer. The little world just keeps spinning and spinning
What should I do? Should I stop the server and restart it? What to do?
The little world icon is still just spinning around.