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 DAC 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
This table is for internal use only. Query the sysdac_instances system view instead.
Permissions
Requires membership in the sysadmin fixed server role.
See Also