Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft