Sql

Search

check sql database table lock

select cmd,* from sys.sysprocesses
where blocked > 0

Comment

check sql database table lock

select cmd,* from sys.sysprocesses
where blocked > 0

Comment

check lock on table in sql server

SELECT
OBJECT_NAME(p.OBJECT_ID) AS TableName,
resource_type, resource_description
FROM
sys.dm_tran_locks l
JOIN sys.partitions p ON l.resource_associated_entity_id = p.hobt_id

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql show schema
Sql :: SQL Server lock table example
Sql :: mysql update with join
Sql :: eliminate zero from integer mysql
Sql :: 1396(hy00) mysql error
Sql :: select list is not in group by clause and contains nonaggregated column codeigniter
Sql :: sql delete all values in a column
Sql :: how to extract only year and month from date in sql
Sql :: sql convert float to string
Sql :: postgres list users
Sql :: full sql mode
Sql :: how to delete the rows with null values in mysql
Sql :: declarative base sqlalchemy
Sql :: empty table sqlite
Sql :: brew start postgres
Sql :: mysql get all tables from a specific database
Sql :: mysql if condition
Sql :: round in sql server
Sql :: between sql server
Sql :: oracle table free space
Sql :: How to drop procedures in mysql ?
Sql :: division by zero postgres
Sql :: check database sessions oracle
Sql :: get max salary from each department sql
Sql :: mysql select count
Sql :: all_dependencies
Sql :: sequence postgresql
Sql :: activate binary log mariadb
Sql :: sql left
Sql :: oracle change tablespace size

Search

SQL

check sql database table lock

check sql database table lock

check lock on table in sql server

ADD CONTENT