Sample Header Ad - 728x90

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 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
enter image description here I can find the 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