TechNet
Export (0) Print
Expand All

sysdac_instances_internal (Transact-SQL)

 

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 nameData typeDescription
instance_iduniqueidentifierIdentifier of the DAC instance.
instance_namesysnameName of the DAC instance specified when the instance was deployed.
type_namesysnameName of the DAC specified when the DAC package was created.
type_versionnvarchar(64)Version of the DAC specified when the DAC package was created.
descriptionnvarchar(4000)A description of the DAC written when the DAC package was created.
type_streamvarbinary(max)A bit stream that contains the encoded representation of the logical objects, such as tables and views, contained in the DAC.
date_createddatetimeDate and time the DAC instance was created.
created_bysysnameLogin 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.

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

Community Additions

ADD
Show:
© 2016 Microsoft