File tree

• docs
  • integration-services
    • system-stored-procedures
      • catalog-add-data-tap-by-guid.md
      • catalog-add-data-tap.md
      • catalog-check-schema-version.md
      • catalog-cleanup-server-execution-keys.md
      • catalog-cleanup-server-log.md
      • catalog-clear-object-parameter-value-ssisdb-database.md
      • catalog-configure-catalog-ssisdb-database.md
      • catalog-create-environment-reference-ssisdb-database.md
      • catalog-create-environment-ssisdb-database.md
      • catalog-create-environment-variable-ssisdb-database.md
      • catalog-create-execution-dump.md
      • catalog-create-execution-ssisdb-database.md
      • catalog-create-folder-ssisdb-database.md
      • catalog-delete-environment-reference-ssisdb-database.md
      • catalog-delete-environment-ssisdb-database.md
      • catalog-delete-environment-variable-ssisdb-database.md
      • catalog-delete-folder-ssisdb-database.md
      • catalog-delete-project-ssisdb-database.md
      • catalog-deny-permission-ssisdb-database.md
      • catalog-deploy-packages.md
      • catalog-deploy-project-ssisdb-database.md
      • catalog-get-parameter-values-ssisdb-database.md
      • catalog-get-project-ssisdb-database.md
      • catalog-grant-permission-ssisdb-database.md
      • catalog-move-environment-ssisdb-database.md
      • catalog-move-project-ssisdb-database.md
      • catalog-remove-data-tap.md
      • catalog-rename-environment-ssisdb-database.md
      • catalog-rename-folder-ssisdb-database.md
      • catalog-restore-project-ssisdb-database.md
      • catalog-revoke-permission-ssisdb-database.md
      • catalog-set-environment-property-ssisdb-database.md
      • catalog-set-environment-reference-type-ssisdb-database.md
      • catalog-set-environment-variable-property-ssisdb-database.md
      • catalog-set-environment-variable-protection-ssisdb-database.md
      • catalog-set-environment-variable-value-ssisdb-database.md
      • catalog-set-execution-parameter-value-ssisdb-database.md
      • catalog-set-execution-property-override-value.md
      • catalog-set-folder-description-ssisdb-database.md
      • catalog-set-object-parameter-value-ssisdb-database.md
      • catalog-set-worker-agent-property-ssisdb-database.md
      • catalog-start-execution-ssisdb-database.md
      • catalog-startup.md
      • catalog-stop-operation-ssisdb-database.md
      • catalog-validate-package-ssisdb-database.md
      • catalog-validate-project-ssisdb-database.md
      • stored-procedures-integration-services-catalog.md
    • system-views
      • catalog-catalog-properties-ssisdb-database.md
      • catalog-effective-object-permissions-ssisdb-database.md
      • catalog-environment-references-ssisdb-database.md
      • catalog-environment-variables-ssisdb-database.md
      • catalog-environments-ssisdb-database.md
      • catalog-event-message-context.md
      • catalog-event-messages.md
      • catalog-executable-statistics.md
      • catalog-executables.md
      • catalog-execution-component-phases.md
      • catalog-execution-data-statistics.md
      • catalog-execution-data-taps.md
      • catalog-execution-parameter-values-ssisdb-database.md
      • catalog-execution-property-override-values.md
      • catalog-executions-ssisdb-database.md
      • catalog-explicit-object-permissions-ssisdb-database.md
      • catalog-extended-operation-info-ssisdb-database.md
      • catalog-folders-ssisdb-database.md
      • catalog-object-parameters-ssisdb-database.md
      • catalog-object-versions-ssisdb-database.md
      • catalog-operation-messages-ssisdb-database.md
      • catalog-operations-ssisdb-database.md
      • catalog-packages-ssisdb-database.md
      • catalog-projects-ssisdb-database.md
      • catalog-validations-ssisdb-database.md
      • views-integration-services-catalog.md
  • relational-databases
    • system-catalog-views
      • filestream-and-filetable-catalog-views-transact-sql.md
      • full-text-search-and-semantic-search-catalog-views-transact-sql.md
      • policy-based-management-views-transact-sql.md
      • querying-the-sql-server-system-catalog-faq.md
      • spatial-data-catalog-views.md
      • sys-availability-databases-cluster-transact-sql.md
      • sys-availability-group-listener-ip-addresses-transact-sql.md
      • sys-availability-group-listeners-transact-sql.md
      • sys-availability-groups-cluster-transact-sql.md
      • sys-availability-groups-transact-sql.md
      • sys-availability-read-only-routing-lists-transact-sql.md
      • sys-availability-replicas-transact-sql.md
      • sys-column-store-dictionaries-transact-sql.md
      • sys-filetable-system-defined-objects-transact-sql.md
      • sys-filetables-transact-sql.md
      • sys-fulltext-semantic-languages-transact-sql.md
      • sys-selective-xml-index-paths-transact-sql.md
    • system-compatibility-views
      • sys-sysconstraints-transact-sql.md
      • sys-sysindexes-transact-sql.md
      • system-compatibility-views-transact-sql.md
    • system-dynamic-management-views
      • always-on-availability-groups-dynamic-management-views-functions.md
      • common-language-runtime-related-dynamic-management-views-transact-sql.md
      • database-related-dynamic-management-views-transact-sql.md
      • extended-events-dynamic-management-views.md
      • i-o-related-dynamic-management-views-and-functions-transact-sql.md
      • index-related-dynamic-management-views-and-functions-transact-sql.md
      • object-related-dynamic-management-views-and-functions-transact-sql.md
      • replication-related-dynamic-management-views-transact-sql.md
      • security-related-dynamic-management-views-and-functions-transact-sql.md
      • server-related-dynamic-management-views-and-functions-transact-sql.md
      • sys-dm-db-uncontained-entities-transact-sql.md
      • sys-dm-fts-index-keywords-by-property-transact-sql.md
      • sys-dm-fts-index-keywords-position-by-document-transact-sql.md
      • sys-dm-hadr-auto-page-repair-transact-sql.md
      • sys-dm-hadr-availability-group-states-transact-sql.md
      • sys-dm-hadr-availability-replica-cluster-nodes-transact-sql.md
      • sys-dm-hadr-availability-replica-cluster-states-transact-sql.md
      • sys-dm-hadr-availability-replica-states-transact-sql.md
      • sys-dm-hadr-cluster-networks-transact-sql.md
      • sys-dm-hadr-cluster-transact-sql.md
      • sys-dm-hadr-database-replica-cluster-states-transact-sql.md
      • sys-dm-hadr-database-replica-states-transact-sql.md
      • sys-dm-hadr-instance-node-map-transact-sql.md
      • sys-dm-hadr-name-id-map-transact-sql.md
      • sys-dm-os-cluster-properties-transact-sql.md
      • sys-dm-resource-governor-resource-pool-affinity-transact-sql.md
      • sys-dm-tcp-listener-states-transact-sql.md
      • transaction-related-dynamic-management-views-and-functions-transact-sql.md
    • system-functions
      • always-on-availability-groups-functions-transact-sql.md
      • filetablerootpath-transact-sql.md
      • fn-syscollector-get-execution-stats-transact-sql.md
      • full-text-search-and-semantic-search-functions-transact-sql.md
      • getfilenamespacepath-transact-sql.md
      • getpathlocator-transact-sql.md
      • semantickeyphrasetable-transact-sql.md
      • semanticsimilaritydetailstable-transact-sql.md
      • semanticsimilaritytable-transact-sql.md
      • sys-fn-hadr-backup-is-preferred-replica-transact-sql.md
      • sys-fn-msxe-read-event-stream-transact-sql.md
      • system-functions-category-transact-sql.md
      • system-metadata-functions.md
      • system-security-functions.md
      • system-trace-functions.md
    • system-stored-procedures
      • catalog-stored-procedures-transact-sql.md
      • cursor-stored-procedures-transact-sql.md
      • database-engine-stored-procedures-transact-sql.md
      • distributed-queries-stored-procedures-transact-sql.md
      • filestream-and-filetable-sp-filestream-force-garbage-collection.md
      • filestream-and-filetable-system-stored-procedures.md
      • general-extended-stored-procedures-transact-sql.md
      • log-shipping-stored-procedures-transact-sql.md
      • object-hierarchy-syntax-transact-sql.md
      • policy-based-management-stored-procedures-transact-sql.md
      • sp-audit-write-transact-sql.md
      • sp-change-users-login-transact-sql.md
      • sp-db-selective-xml-index-transact-sql.md
      • sp-delete-log-shipping-primary-database-transact-sql.md
      • sp-droptype-transact-sql.md
      • sp-get-redirected-publisher-transact-sql.md
      • sp-help-spatial-geography-histogram-transact-sql.md
      • sp-help-spatial-geography-index-transact-sql.md
      • sp-help-spatial-geography-index-xml-transact-sql.md
      • sp-help-spatial-geometry-histogram-transact-sql.md
      • sp-help-spatial-geometry-index-transact-sql.md
      • sp-help-spatial-geometry-index-xml-transact-sql.md
      • sp-migrate-user-to-contained-transact-sql.md
      • sp-prepexecrpc-transact-sql.md
      • sp-redirect-publisher-transact-sql.md
      • sp-server-diagnostics-transact-sql.md
      • sp-syspolicy-purge-health-state-transact-sql.md
      • sp-validate-redirected-publisher-transact-sql.md
      • sp-validate-replica-hosts-as-publishers-transact-sql.md
      • spatial-index-stored-procedures-arguments-and-properties.md
      • sql-server-agent-stored-procedures-transact-sql.md
      • xml-stored-procedures-transact-sql.md
      • xp-sprintf-transact-sql.md
    • system-tables
      • backup-and-restore-tables-transact-sql.md
      • database-maintenance-plan-tables-transact-sql.md
      • dbo-systargetservergroupmembers-transact-sql.md
      • extended-events-tables-trace-xe-action-map.md
      • extended-events-tables-trace-xe-event-map.md
      • integration-services-tables-transact-sql.md
      • replication-tables-transact-sql.md
      • sql-server-agent-tables-transact-sql.md
      • system-tables-transact-sql.md
    • system-views
      • replication-views-transact-sql.md
    • tables
      • lesson-1-converting-a-table-to-a-hierarchical-structure.md
      • lesson-2-creating-and-managing-data-in-a-hierarchical-table.md
  • t-sql
    • data-types
      • data-type-synonyms-transact-sql.md
      • date-and-time-types.md
      • precision-scale-and-length-transact-sql.md
    • database-console-commands
      • dbcc-clonedatabase-transact-sql.md
    • functions
      • data-type-functions-transact-sql.md
      • metadata-functions-transact-sql.md
      • security-functions-transact-sql.md
      • system-functions-transact-sql.md
      • system-statistical-functions-transact-sql.md
      • trigger-functions-transact-sql.md
    • language-elements
      • comparison-operators-transact-sql.md
      • control-of-flow.md
      • logical-operators-transact-sql.md
      • string-operators-transact-sql.md
      • transaction-isolation-levels.md
    • queries
      • hints-transact-sql.md
      • predicates.md
    • statements
      • alter-availability-group-transact-sql.md
      • alter-database-transact-sql-set-hadr.md
      • alter-search-property-list-transact-sql.md
      • create-availability-group-transact-sql.md
      • create-server-role-transact-sql.md
      • deny-availability-group-permissions-transact-sql.md
      • drop-availability-group-transact-sql.md
      • drop-search-property-list-transact-sql.md
      • grant-availability-group-permissions-transact-sql.md
    • xml
      • guidelines-for-using-xml-data-type-methods.md
      • xml-data-type-methods.md