Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Database Engine
Technical Reference
 sys.dm_os_loaded_modules (Transact-...
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
SQL Server 2008 Books Online (October 2009)
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.

Requires VIEW SERVER STATE permission on the server.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement | Site Feedback
Page view tracker