Data-tier Application Tables - sysdac_instances_internal
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.