Data-tier Application Tables - sysdac_instances_internal

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

Data-tier Applications
dbo.sysdac_instances (Transact-SQL)