Rather urgent one.
Have created an index on one of our tables and for some reason all data going into that table has stopped.
Can't see any blocking, but when I'm trying to drop or disable the index with either
ALTER INDEX [IX_DataCapture_Received] ON [queue].[queued_datacapture_data] DISABLE DROP INDEX [IX_DataCapture_Received] ON [queue].[queued_datacapture_data] WITH ( ONLINE = OFF, MAXDOP = 1)
I get a report of deadlock preventing it, but nothing is being reported to sp_readerrorlog
Any clues as to what's going on?