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.