.png)
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 |
