data-tier-application-tables-sysdac-instances-internal.md

title	sysdac_instances_internal (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sysdac_instances_internal_TSQL sysdac_instances_internal
dev_langs	TSQL
helpviewer_keywords	sysdac_instances_internal
ms.assetid	d2d52cc4-3463-431a-b779-6fbfdeee1dfc
author	stevestein
ms.author	sstein

Data-tier Application Tables - sysdac_instances_internal

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Displays one row for each data-tier application (DAC) instance deployed to an instance of the [!INCLUDEssDE]. 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

Remarks

Read-only access to this view is available to all users with permissions to connect to the master database.

Permissions

Requires membership in the sysadmin fixed server role.

See Also

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