Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sys.dm_os_loaded_modules (Transact-SQL)

sys.dm_os_loaded_modules (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Data Warehouse Public Preview.

System_CAPS_noteNote

To call this from SQL 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.

Requires VIEW SERVER STATE permission on the server.

Community Additions

ADD
Show:
© 2015 Microsoft