dm_os_loaded_modules

This is a view in the mssqlsystemresource database. Returns a row for each module loaded into the server.

CREATE VIEW sys.dm_os_loaded_modules AS     SELECT *     FROM OpenRowSet(TABLE SYSMODULES)