SYSK 170: Under the Hood of SQL System Objects

Want to know what’s inside sp_help stored proc? How about TABLE_PRIVILEGES view?


All the system objects definitions are now stored in the hidden read-only resource database (a.k.a. RDB) physically persisted in mssqlsystemresource.mdf. 


You can view the system objects definitions by running the following query:

select object_definition(object_id)

from sys.system_objects

where name = ‘sys_object_name_here’


If you’re interested in learning more about RDB, there is a good article at



Comments (0)