Features Outside of the Application Model (Partially Contained Database)

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

The system objects listed in the tables below reside outside of the application boundary, e.g. at the instance level. See Partially Contained Databases for further information on these terms.

Any entity within the application model that uses any of the features listed below is considered uncontained.

See Features Within the Application Model (Partially Contained Database) for a complete list of those features that may be used by entities within the application model.

sys.asymmetric_keys

sys.backup_devices

sys.certificates

sys.configurations

sys.credentials

sys.crypt_properties

sys.cryptographic_providers

sys.database_audit_specification_details

sys.database_audit_specifications

sys.database_files

sys.database_mirroring

sys.database_mirroring_endpoints

sys.database_mirroring_witnesses

sys.database_recovery_status

sys.endpoint_webmethods

sys.endpoints

sys.extended_procedures

sys.fulltext_semantic_language_statistics_database

sys.http_endpoints

sys.internal_tables

sys.key_encryptions

sys.linked_logins

sys.master_files

sys.master_key_passwords

sys.numbered_procedure_parameters

sys.numbered_procedures

sys.remote_logins

sys.remote_service_bindings

sys.resource_governor_configuration

sys.resource_governor_resource_pools

sys.resource_governor_workload_groups

sys.server_audit_specification_details

sys.server_audits

sys.server_event_notifications

sys.server_event_session_actions

sys.server_event_session_events

sys.server_event_session_fields

sys.server_event_session_targets

sys.server_event_sessions

sys.server_events

sys.server_file_audits

sys.server_permissions

sys.server_principals

sys.server_role_members

sys.server_sql_modules

sys.internal_tables

sys.server_triggers

sys.server_trigger_events

sys.service_broker_endpoints

sys.servers

sys.service_contract_usages

sys.service_contract_message_usages

sys.service_message_types

sys.service_contracts

sys.service_queues

sys.service_queue_usages

sys.soap_endpoints

sys.services

sys.sql_logins

sys.sql_dependencies

sys.system_components_surface_area_configuration

sys.symmetric_keys

sys.tcp_endpoints

sys.tcp_endpoints

sys.trace_categories

sys.trace_categories

sys.trace_columns

sys.trace_columns

sys.trace_event_bindings

sys.trace_event_bindings

sys.trace_events

sys.trace_events

sys.trace_subclass_values

sys.trace_subclass_values

sys.via_endpoints

sys.traces

Compatibility Views

sys.altfiles

sys.cacheobjects

sys.charsets

sys.columns

sys.comments

sys.configures

sys.constraints

sys.curconfigs

sys.databases

sys.depends

sys.devices

sys.filegroups

sys.files

sys.foreignkeys

sys.fulltextcatalogs

sys.indexes

sys.indexkeys

sys.languages

sys.lockinfo

sys.logins

sys.members

sys.messages

sys.objects

sys.perfinfo

sys.permissions

sys.processes

sys.protects

sys.references

sys.remotelogins

sys.servers

sys.types

sys.types

sys.users

sys.users

CREATE/DROP/ALTER Statements

ALTER RESOURCE GOVERNOR

ALTER SERVICE MASTER KEY

CREATE/ALTER/DROP ASYMMETRIC KEY

CREATE/ALTER/DROP CERTIFICATE

CREATE/ALTER/DROP CRYPTOGRAPHIC PROVIDER

CREATE/ALTER/DROP DATABASE AUDIT SPECIFICATION

CREATE/ALTER/DROP DATABASE ENCRYPTION KEY

CREATE/ALTER/DROP DEFAULT

CREATE/ALTER/DROP ENDPOINT

CREATE/ALTER/DROP EVENT SESSION

CREATE/ALTER/DROP MASTER KEY

CREATE/ALTER/DROP REMOTE SERVICE BINDING

CREATE/ALTER/DROP RESOURCE POOL

CREATE/ALTER/DROP ROUTE

CREATE/ALTER/DROP SERVER AUDIT

CREATE/ALTER/DROP SERVER AUDIT SPECIFICATION

CREATE/ALTER/DROP SYMMETRIC KEY

CREATE/ALTER/DROP SYNONYM

CREATE/ALTER/DROP WORKLOAD GROUP

CREATE/DROP RULE

CREATE TABLE elements

FILESTREAM_ON

ON clause

schema_element

TEXTIMAGE_ON

GRANT/DENY/REVOKE Statements

GRANT/REVOKE/DENY Asymmetric Key Permissions

GRANT/REVOKE/DENY Certificate Permissions

GRANT/REVOKE/DENY Endpoint Permissions

GRANT/REVOKE/DENY Server Permissions

GRANT/REVOKE/DENY Server Principal Permissions

GRANT/REVOKE/DENY Symmetric Key Permissions

SET Statements

SET ANSI_NULLS

SET ANSI_PADDING

SET CONCAT_NULL_YIELDS_NULL

SET DISABLE_DEF_CNST_CHK

SET OFFSETS

SET QUERY_GOVERNOR_COST_LIMIT

SET REMOTE_PROC_TRANSACTIONS

SETUSER

Miscellaneous Transact-SQL Statements

ADD SIGNATURE

BACKUP

BACKUP CERTIFICATE

BACKUP MASTER KEY

BACKUP SERVICE MASTER KEY

BEGIN DISTRIBUTED TRANSACTION

BULK INSERT

CHECKPOINT

CLOSE MASTER KEY

CLOSE SYMMETRIC KEY

IDENTITY

KILL QUERY NOTIFICATION SUBSCRIPTION

KILL STATS JOB

OPEN MASTER KEY

OPEN SYMMETRIC KEY

OPENDATASOURCE

OPENQUERY

OPENROWSET

OPENXML

PathName

READTEXT

RECONFIGURE

RESTORE

RESTORE FILELISTONLY

RESTORE HEADERONLY

RESTORE MASTER KEY

RESTORE SERVICE MASTER KEY

RESTORE VERIFYONLY

SHUTDOWN

Trace Flags

UPDATETEXT

WRITETEXT

@@CONNECTIONS

@@CPU_BUSY

@@IDLE

@@IO_BUSY

@@MAX_CONNECTIONS

@@PACK_RECEIVED

@@PACK_SENT

@@PACKET_ERRORS

@@REMSERVER

@@SERVERNAME

@@SERVICENAME

@@SPID

@@TOTAL_ERRORS

@@TOTAL_READ

@@TOTAL_WRITE

ASYMKEY_ID

ASYMKEYPROPERTY

CERT_ID

CERTPROPERTY

CONNECTIONPROPERTY

DATABASEPROPERTYEX

DECRYPTBYASYMKEY

DECRYPTBYCERT

DECRYPTBYKEY

DECRYPTBYKEYAUTOASYMKEY

DECRYPTBYKEYAUTOCERT

DECRYPTBYPASSPHRASE

ENCRYPTBYASYMKEY

ENCRYPTBYCERT

ENCRYPTBYKEY

ENCRYPTBYPASSPHRASE

FILE_ID

FILE_IDEX

FILE_NAME

FILEPROPERTY

GET_TRANSMISSION_STATUS

HAS_DBACCESS

HOST_ID

HOST_NAME

INDEXKEY_PROPERTY

IS_OBJECTSIGNED

IS_SRVROLEMEMBER

KEY_GUID

KEY_ID

KEY_NAME

LOGINPROPERTY

NEWSEQUENTIALID

PUBLISHINGSERVERNAME

SIGNBYASYMKEY

SIGNBYCERT

SYMKEYPROPERTY

TEXTPTR

TEXTVALID

USER_ID

VERIFYSIGNEDBYASYMKEY

VERIFYSIGNEDBYCERT

cdc.fn_cdc_get_all_changes_<capture_instance>

cdc.fn_cdc_get_net_changes_<capture_instance>

snapshots.fn_trace_getdata

sys.fn_all_changes_<capture_instance>

sys.fn_cdc_decrement_lsn

sys.fn_cdc_get_column_ordinal

sys.fn_cdc_get_max_lsn

sys.fn_cdc_get_min_lsn

sys.fn_cdc_has_column_changed

sys.fn_cdc_hexstrtobin

sys.fn_cdc_increment_lsn

sys.fn_cdc_is_bit_set

sys.fn_cdc_map_lsn_to_time

sys.fn_cdc_map_time_to_lsn

sys.fn_check_object_signatures

sys.fn_get_audit_file

sys.fn_get_sql

sys.fn_IsBitSetInBitmask

sys.fn_net_changes_<capture_instance>

sys.fn_syscollector_get_execution_details

sys.fn_syscollector_get_execution_stats

sys.fn_trace_geteventinfo

sys.fn_trace_getinfo

sys.fn_trace_gettable

sys.fn_translate_permissions

sys.fn_virtualfilestats

sys.fn_virtualservernodes

sys.fn_xe_file_target_read_file

sys.sfn_servershareddrives

Feature

Description

$$PARTITION

 

Change Data Capture

Change data capture is not supported in a contained database.

Files

Any operations on files cross the application boundary.

Full-text Search

 

Linked servers

Linked servers are uncontained because their definition resides in the master database, which is outside of the application boundary.

Synonyms

Synonyms cross the application boundary only if the reference standing on its own would. For example, a synonym to an object using a three- or four-part name.

Show: