sysdac_instances_internal (Transact-SQL)
Displays one row for each data-tier application (DAC) instance deployed to an instance of the Database Engine. This table is stored in the dbo schema in the msdb database.
Column name |
Data type |
Description |
|---|---|---|
instance_id |
uniqueidentifier |
Identifier of the DAC instance. |
instance_name |
sysname |
Name of the DAC instance specified when the instance was deployed. |
type_name |
sysname |
Name of the DAC specified when the DAC package was created. |
type_version |
nvarchar(64) |
Version of the DAC specified when the DAC package was created. |
description |
nvarchar(4000) |
A description of the DAC written when the DAC package was created. |
type_stream |
varbinary(max) |
A bit stream that contains the encoded representation of the logical objects, such as tables and views, contained in the DAC. |
date_created |
datetime |
Date and time the DAC instance was created. |
created_by |
sysname |
Login that created the DAC instance |
Remarks
Read-only access to this view is available to all users with permissions to connect to the master database.
Permissions
Requires membership in the sysadmin fixed server role.
See Also
Reference
dbo.sysdac_instances (Transact-SQL)