sys.dm_os_loaded_modules (Transact-SQL)


THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse yesParallel Data Warehouse

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

System_CAPS_ICON_note.jpg Note

To call this from Parallel Data Warehouse, use the name sys.dm_pdw_nodes_os_loaded_modules.

Column nameData typeDescription
base_addressvarbinary(8)Address of the module in the process.
file_versionvarchar(23)Version of the file. Appears in the following format:

product_versionvarchar(23)Version of the product. Appears in the following format:

debugbit1 = Module is a debug version of the loaded module.
patchedbit1 = Module has been patched.
prereleasebit1 = Module is a pre-release version of the loaded module.
private_buildbit1 = Module is a private build of the loaded module.
special_buildbit1 = Module is a special build of the loaded module.
languageintLanguage of version information of the module.
companynvarchar(256)Name of company that created the module.
descriptionnvarchar(256)Description of the module.
namenvarchar(255)Name of module. Includes the full path of the module.
pdw_node_idintApplies to: Parallel Data Warehouse

The identifier for the node that this distribution is on.

Requires VIEW SERVER STATE permission on the server.

Dynamic Management Views and Functions (Transact-SQL)
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)

Community Additions