{"id":11665,"date":"2021-09-23T19:59:38","date_gmt":"2021-09-23T18:59:38","guid":{"rendered":"https:\/\/sdna.lu\/?p=11665"},"modified":"2021-09-23T19:59:40","modified_gmt":"2021-09-23T18:59:40","slug":"query-display-sql-process-locked-record","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=11665","title":{"rendered":"Query: Display SQL process (locked record)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">SELECT<br>db_name(rsc_dbid) AS &#8216;DATABASE_NAME&#8217;,<br>case rsc_type when 1 then &#8216;null&#8217;<br>when 2 then &#8216;DATABASE&#8217;<br>WHEN 3 THEN &#8216;FILE&#8217;<br>WHEN 4 THEN &#8216;INDEX&#8217;<br>WHEN 5 THEN &#8216;TABLE&#8217;<br>WHEN 6 THEN &#8216;PAGE&#8217;<br>WHEN 7 THEN &#8216;KEY&#8217;<br>WHEN 8 THEN &#8216;EXTEND&#8217;<br>WHEN 9 THEN &#8216;RID ( ROW ID)&#8217;<br>WHEN 10 THEN &#8216;APPLICATION&#8217; end AS &#8216;REQUEST_TYPE&#8217;,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">CASE req_ownertype WHEN 1 THEN &#8216;TRANSACTION&#8217;<br>WHEN 2 THEN &#8216;CURSOR&#8217;<br>WHEN 3 THEN &#8216;SESSION&#8217;<br>WHEN 4 THEN &#8216;ExSESSION&#8217; END AS &#8216;REQUEST_OWNERTYPE&#8217;,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">OBJECT_NAME(rsc_objid ,rsc_dbid) AS &#8216;OBJECT_NAME&#8217;,<br>PROCESS.HOSTNAME ,<br>PROCESS.program_name ,<br>PROCESS.nt_domain ,<br>PROCESS.nt_username ,<br>PROCESS.program_name ,<br>SQLTEXT.text<br>FROM sys.syslockinfo LOCK JOIN<br>sys.sysprocesses PROCESS<br>ON LOCK.req_spid = PROCESS.spid<br>CROSS APPLY sys.dm_exec_sql_text(PROCESS.SQL_HANDLE) SQLTEXT<br>where db_name(rsc_dbid) = &#8216;DeMaSy&#8217;<br>And req_ownertype = 1<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECTdb_name(rsc_dbid) AS &#8216;DATABASE_NAME&#8217;,case rsc_type when 1 then &#8216;null&#8217;when 2 then &#8216;DATABASE&#8217;WHEN 3 THEN &#8216;FILE&#8217;WHEN 4 THEN &#8216;INDEX&#8217;WHEN 5 THEN &#8216;TABLE&#8217;WHEN 6 THEN &#8216;PAGE&#8217;WHEN 7 THEN &#8216;KEY&#8217;WHEN 8 THEN &#8216;EXTEND&#8217;WHEN 9 THEN &#8216;RID ( ROW ID)&#8217;WHEN 10 THEN &#8216;APPLICATION&#8217; end AS &#8216;REQUEST_TYPE&#8217;, CASE req_ownertype WHEN 1 THEN &#8216;TRANSACTION&#8217;WHEN 2 THEN &#8216;CURSOR&#8217;WHEN 3 THEN &#8216;SESSION&#8217;WHEN 4 THEN [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[487],"tags":[],"class_list":["post-11665","post","type-post","status-publish","format-standard","hentry","category-query"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/11665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11665"}],"version-history":[{"count":1,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/11665\/revisions"}],"predecessor-version":[{"id":11666,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/11665\/revisions\/11666"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}