SQLServerのテーブルロック状態を取得するSQLSELECT resource_type AS type ,resource_associated_entity_id as entity_id ,( CASE WHEN resource_type = 'OBJECT' THEN OBJECT_NAME( resource_associated_entity_id ) ELSE ( SELECT OBJECT_NAME( OBJECT_ID ) FROM sys.partitions WHERE hobt_id=resource_associated_entity_id ) END) AS object_name ,request_mode AS request_mode ,request_type AS request_type ,request_status AS request_status ,request_session_id
