Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server Analytics Platform System (PDW)
Returns a row for each module loaded into the server address space.
Note
To call this from Analytics Platform System (PDW), 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: Analytics Platform System (PDW) 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)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register today