sys.dm_os_loaded_modules (Transact-SQL)

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

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.

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Reference

Dynamic Management Views and Functions (Transact-SQL)

SQL Server Operating System Related Dynamic Management Views (Transact-SQL)