Events
31 Mar, 23 - 2 Apr, 23
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayData-tier Application Tables - sysdac_instances_internal
Applies to: 
SQL Server
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 |
Read-only access to this view is available to all users with permissions to connect to the master database.
Requires membership in the sysadmin fixed server role.