| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_os_loaded_modules (Transact-SQL) |
sys.dm_os_loaded_modules (Transact-SQL) |
rwestMSFT |
randolphwest |
02/27/2023 |
sql |
system-objects |
reference |
|
|
|
>=sql-server-2016||>=sql-server-linux-2017||>=aps-pdw-2016 |
[!INCLUDE sql-pdw]
Returns a row for each module loaded into the server address space.
Note
To call this from [!INCLUDEssPDW], 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: [!INCLUDEssPDW] The identifier for the node that this distribution is on. |
Requires VIEW SERVER STATE permission on the server.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Dynamic Management Views and Functions (Transact-SQL)
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)