This is easier
IF OBJECT_ID('tempdb..#dbccoptions') IS NOT NULL
BEGIN
DROP TABLE #dbccoptions
END
CREATE TABLE #dbccoptions
(
[parentobject] VARCHAR(32)
, [object]VARCHAR(32)
, [field]VARCHAR(32)
, [value]VARCHAR(64)
)
INSERT INTO #dbccoptions
EXEC('DBCC DBINFO WITH TABLERESULTS')
SELECT field, value
FROM #dbccoptions
WHERE field = 'dbi_dbccFlags'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉