sys.dm_os_loaded_modules  is a SQL Server OS Dynamic Management View (DMV).

When executing the t-sql statement below – a recordset is returned . I’ve included some output further down the page :

select file_version,product_version,company,[description] from sys.dm_os_loaded_modules  

I find this dmv useful when troubleshooting corruption .

An example , is to  check if there is any anti-virus module which is getting loaded in the SQL memory area. Normally , I’m looking for non-Microsoft Corporation modules .

Returns a row for each module loaded into the server address space.

2005.90:4340.09.0:4340.0Microsoft CorporationSQL Server Windows NT
5.2:3790.47895.2:3790.4789Microsoft CorporationNT Layer DLL
5.2:3790.44805.2:3790.4480Microsoft CorporationWindows NT BASE API Client DLL
8.0:50727.30538.0:50727.3053Microsoft CorporationMicrosoft® C Runtime Library
7.0:3790.39596.1:8638.3959Microsoft CorporationWindows NT CRT DLL
8.0:50727.30538.0:50727.3053Microsoft CorporationMicrosoft® C++ Runtime Library
5.2:3790.44555.2:3790.4455Microsoft CorporationAdvanced Windows 32 Base API
5.2:3790.47595.2:3790.4759Microsoft CorporationRemote Procedure Call Runtime
5.2:3790.45305.2:3790.4530Microsoft CorporationSecurity Support Provider Interface
2005.90:4035.09.0:4035.0Microsoft CorporationSQLOS Hosting DLL

Author: Jack Vamvas (http://www.sqlserver-dba.com)