Tagged Questions
2
votes
1answer
111 views
Database locked
I canceled a query which took too long time. After that, the SQL-Server database was locked. After I restarted SQL Server, the mode of my database was "in recovery". Now I can't access my database ...
1
vote
1answer
65 views
SQL Server 2008 - get current LOCK_ESCALATION on particular table
Is there a way to find the current setting for LOCK_ESCALATION on particular table? Can it be found through system views?
