sys-dm-os-loaded-modules-transact-sql.md

title	sys.dm_os_loaded_modules (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/18/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.dm_os_loaded_modules dm_os_loaded_modules sys.dm_os_loaded_modules_TSQL dm_os_loaded_modules_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.dm_os_loaded_modules dynamic management view
ms.assetid	56c7743a-b568-4943-bd3b-73c57d9d641c
caps.latest.revision	20
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

sys.dm_os_loaded_modules (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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.

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)