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.
Reference
Dynamic Management Views and Functions (Transact-SQL)
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)
Help and Information
Getting SQL Server 2008 Assistance