Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.