db check lock status

# mssql server

# SOURCE: http://dba.stackexchange.com/questions/57432/database-is-in-transition-error
SELECT
    l.resource_type,
    l.request_mode,
    l.request_status,
    l.request_session_id,
    r.command,
    r.STATUS,
    r.blocking_session_id,
    r.wait_type,
    r.wait_time,
    r.wait_resource,
    request_sql_text = st.text,
    s.program_name,
    most_recent_sql_text = stc.text
FROM sys.dm_tran_locks l
LEFT JOIN sys.dm_exec_requests r
ON l.request_session_id = r.session_id
LEFT JOIN sys.dm_exec_sessions s
ON l.request_session_id = s.session_id
LEFT JOIN sys.dm_exec_connections c
ON s.session_id = c.session_id
OUTER apply sys.dm_exec_sql_text(r.sql_handle) st
OUTER apply sys.dm_exec_sql_text(c.most_recent_sql_handle) stc
WHERE l.resource_database_id = db_id('<db name goes here>')
ORDER BY request_session_id;