Export (0) Print
Expand All

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 DAC 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.

This table is for internal use only. Query the sysdac_instances system view instead.

Requires membership in the sysadmin fixed server role.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft