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.

Note

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

Column name Data type Description
base_address varbinary(8) Address of the module in the process.
file_version varchar(23) Version of the file. Appears in the following format:

x.x:x.x
product_version varchar(23) Version of the product. Appears in the following format:

x.x:x.x
debug bit 1 = Module is a debug version of the loaded module.
patched bit 1 = Module has been patched.
prerelease bit 1 = Module is a pre-release version of the loaded module.
private_build bit 1 = Module is a private build of the loaded module.
special_build bit 1 = Module is a special build of the loaded module.
language int Language of version information of the module.
company nvarchar(256) Name of company that created the module.
description nvarchar(256) Description of the module.
name nvarchar(255) Name of module. Includes the full path of the module.
pdw_node_id int Applies to: Parallel Data Warehouse

The identifier for the node that this distribution is on.

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

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