Finding the names of objects in the Resource database
3
votes
1
answer
317
views
I'm looking at the sys.dm_exec_function_stats view to find scalar function stats. That view also includes rows from a database with an id **32767**, which I've found is the [Resource database](https://learn.microsoft.com/en-us/sql/relational-databases/databases/resource-database?view=sql-server-ver16#accessing-the-resource-database).
Some of these IDs can be passed to
I can find the
OBJECT_NAME()
or OBJECT_DEFINITION()
Metadata functions but some IDs return NULL
SELECT SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion'
SELECT SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime'
SELECT
defs.database_id
, defs.object_id
, OBJECT_NAME(defs.object_id) AS objName
, OBJECT_DEFINITION(defs.object_id) AS objDef
, OBJECT_NAME(defs.object_id, defs.database_id) AS objNameDB
, OBJECT_DEFINITION(defs.object_id, defs.database_id) AS objDefDB
FROM sys.dm_exec_function_stats AS defs
WHERE defs.database_id = 32767

fn_hadr_is_primary_replica
function (object_id = -665919249) in the sys.all_objects
or in sys.all_sql_modules
, but not the object_id = -706609674.
Is there any way how to find the object name or definition of the -706609674?
Asked by Zikato
(5724 rep)
Aug 3, 2022, 09:52 AM
Last activity: Aug 3, 2022, 12:57 PM
Last activity: Aug 3, 2022, 12:57 PM