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 ...
Is there a way to find the current setting for LOCK_ESCALATION on particular table? Can it be found through system views?