_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁

Contents

1
2 谿瑚襭


1 #

WITH x
AS
(
	SELECT 
		CONVERT(xml, 
			'<r>' + 
			REPLACE(
				REPLACE([Lock Information], 'ACQUIRE_LOCK_SCH_M OBJECT: ', '')
				, ':', '</r><r>'
			) +
			'</r>'
		) xitems
	FROM ::fn_dblog (NULL, NULL)
	WHERE [Lock Information] LIKE '%SCH_M OBJECT%'
	AND [Transaction Id] IN (
		SELECT [Transaction Id]
		FROM ::fn_dblog (NULL, NULL)
		WHERE [Transaction Name] = 'DROPOBJ'
	)
)
SELECT
	xitems.value('/r[1]', 'int') [DB ID]
,	xitems.value('/r[2]', 'int') [Object ID]
FROM x

蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

谿碁 覲旧 覲伎伎 . 谿碁 覲旧 讌襷 蠍 殊 襷譟燕螻 蠍 蠏瑚 谿城 蟆襷 覲伎企襦 螳襷 螳襷 谿場.