enrique.mallon (7/12/2014)
Hi tommySuch condition arises when SQL Server database becomes deadlock and you are unable to perform action or transaction on it. It means that your SQL database got trapped in Suspect mode and for this i think this tutorial may be relevant to you by which you can solve this issue.
I don't agree either. This is a very dangerous approach and can lead to severe data loss. Go to your backups and restore in this situation. If you don't have backups, well, now is a really good time to start.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning