简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

SqlServer查看锁

WBOY
Release： 2016-06-07 15:44:30
Original
1077 people have browsed it

SELECT request_session_id sessionid, resource_type type, resource_database_id dbid, OBJECT_NAME(resource_associated_entity_id, resource_database_id) objectname, request_mode rmode, request_status rstatus FROM sys.dm_tran_locks WHERE resour

SELECT request_session_id sessionid,
resource_type type,
resource_database_id dbid,
OBJECT_NAME(resource_associated_entity_id, resource_database_id) objectname,
request_mode rmode,
request_status rstatus
FROM sys.dm_tran_locks
WHERE resource_type IN ('DATABASE', 'OBJECT')

-- exec('kill 51') 解除锁 51-> dbid

Related labels：
request select sqlserver Check
source：php.cn
Previous article：oracle的Top n时排序问题 Next article：SQLServer2005 NVARCHAR 和VARCHAR区别和使用
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
XAMPP/SQLSRV: Unable to find Sqlsrv in PHPINFO(); - error from connection I'm trying to connect to my SQLServer database hosted on a LinuxVM. I'm running xampp on m...
From 2023-11-09 22:34:33
0
1
172
MySQL - Convert rows to columns I tried searching posts but only found solutions for SQLServer/Access. I need a solution i...
From 2023-10-13 11:50:31
0
1
232
Why is there only column name but no where equal to value in MySQL? It is not a syntax error Why is such a query not a syntax error? I have a SQLServer background and I'm really surpr...
From 2023-09-16 10:37:20
0
1
295
Experiment with sorting after query limit So this is my first question here, please forgive me if something is wrong. I'm trying to ...
From 2023-09-05 14:46:42
0
1
350
Background or font color in HTML is red I have the following code to send email notifications to recipients and it works great. Th...
From 2023-09-03 09:18:19
0
1
333
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！