_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 碁襦蠏語DROP企谿城覦覯

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

Youth is not a time of life but it is a state of mind. (覓伎碁)