Merge pull request #19944 from niko-neugebauer/dbcc-fix

Court72 · web-flow · commit 78df703f20ee · 2021-08-06T07:08:02.000-07:00
DBCC support for SQL MI
diff --git a/docs/t-sql/database-console-commands/dbcc-checkalloc-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-checkalloc-transact-sql.md
@@ -31,7 +31,7 @@ ms.author: umajay
 
 # DBCC CHECKALLOC (Transact-SQL)
 
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Checks the consistency of disk space allocation structures for a specified database.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-checkcatalog-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-checkcatalog-transact-sql.md
@@ -26,7 +26,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC CHECKCATALOG (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   Checks for catalog consistency within the specified database. The database must be online.  
   
diff --git a/docs/t-sql/database-console-commands/dbcc-checkconstraints-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-checkconstraints-transact-sql.md
@@ -28,7 +28,7 @@ ms.author: umajay
 
 # DBCC CHECKCONSTRAINTS (Transact-SQL)
 
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Checks the integrity of a specified constraint or all constraints on a specified table in the current database.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-checkdb-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-checkdb-transact-sql.md
@@ -37,7 +37,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC CHECKDB (Transact-SQL)
-[!INCLUDE [SQL Server Azure SQL Database ](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Checks the logical and physical integrity of all the objects in the specified database by performing the following operations:    
     
diff --git a/docs/t-sql/database-console-commands/dbcc-checkfilegroup-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-checkfilegroup-transact-sql.md
@@ -28,7 +28,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC CHECKFILEGROUP (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 Checks the allocation and structural integrity of all tables and indexed views in the specified filegroup of the current database.
 ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)
   
diff --git a/docs/t-sql/database-console-commands/dbcc-checktable-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-checktable-transact-sql.md
@@ -29,7 +29,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC CHECKTABLE (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Checks the integrity of all the pages and structures that make up the table or indexed view.
 
diff --git a/docs/t-sql/database-console-commands/dbcc-cleantable-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-cleantable-transact-sql.md
@@ -31,7 +31,7 @@ ms.author: umajay
 
 # DBCC CLEANTABLE (Transact-SQL)
 
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 Reclaims space from dropped variable-length columns in tables or indexed views.
 ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)
   
diff --git a/docs/t-sql/database-console-commands/dbcc-dbreindex-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-dbreindex-transact-sql.md
@@ -25,7 +25,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC DBREINDEX (Transact-SQL)
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi.md)]
 Rebuilds one or more indexes for a table in the specified database.
   
 > [!IMPORTANT]  
diff --git a/docs/t-sql/database-console-commands/dbcc-freesessioncache-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-freesessioncache-transact-sql.md
@@ -25,7 +25,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC FREESESSIONCACHE (Transact-SQL)
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi.md)]
 
 Flushes the distributed query connection cache used by distributed queries against an instance of [!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].
   
diff --git a/docs/t-sql/database-console-commands/dbcc-freesystemcache-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-freesystemcache-transact-sql.md
@@ -27,7 +27,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC FREESYSTEMCACHE (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Releases all unused cache entries from all caches. The [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] proactively cleans up unused cache entries in the background to make memory available for current entries. However, you can use this command to manually remove unused entries from every cache or from a specified Resource Governor pool cache.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-help-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-help-transact-sql.md
@@ -21,7 +21,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC HELP (Transact-SQL)
-[!INCLUDE [SQL Server - ASDBMI](../../includes/applies-to-version/sql-asdbmi.md)]
+[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi.md)]
 
 Returns syntax information for the specified DBCC command.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-indexdefrag-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-indexdefrag-transact-sql.md
@@ -28,7 +28,7 @@ ms.author: umajay
 
 # DBCC INDEXDEFRAG (Transact-SQL)
 
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi.md)]
 
 Defragments indexes of the specified table or view.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-inputbuffer-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-inputbuffer-transact-sql.md
@@ -26,7 +26,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC INPUTBUFFER (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Displays the last statement sent from a client to an instance of [!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].
   
diff --git a/docs/t-sql/database-console-commands/dbcc-opentran-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-opentran-transact-sql.md
@@ -28,7 +28,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC OPENTRAN (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 DBCC OPENTRAN helps to identify active transactions that may be preventing log truncation. DBCC OPENTRAN displays information about the oldest active transaction and the oldest distributed and nondistributed replicated transactions, if any, within the transaction log of the specified database. Results are displayed only if there is an active transaction that exists in the log or if the database contains replication information. An informational message is displayed if there are no active transactions in the log.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-outputbuffer-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-outputbuffer-transact-sql.md
@@ -24,7 +24,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC OUTPUTBUFFER (Transact-SQL)
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi.md)]
 
 Returns the current output buffer in hexadecimal and ASCII format for the specified *session_id*.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-proccache-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-proccache-transact-sql.md
@@ -26,7 +26,7 @@ ms.author: umajay
 
 # DBCC PROCCACHE (Transact-SQL)
 
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Displays information in a table format about the procedure cache.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-showcontig-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-showcontig-transact-sql.md
@@ -28,7 +28,7 @@ ms.author: umajay
 
 # DBCC SHOWCONTIG (Transact-SQL)
 
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi.md)]
 
 Displays fragmentation information for the data and indexes of the specified table or view.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-shrinkdatabase-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-shrinkdatabase-transact-sql.md
@@ -31,7 +31,7 @@ ms.author: umajay
 monikerRange: "= azuresqldb-current ||>= sql-server-2016 ||>= sql-server-linux-2017||=azure-sqldw-latest"
 ---
 # DBCC SHRINKDATABASE (Transact-SQL)
-[!INCLUDE [sql-asdb-asa.md](../../includes/applies-to-version/sql-asdb-asa.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance Azure Synapse Analytics](../../includes/applies-to-version/sql-asdb-asdbmi-asa.md)]
 
 Shrinks the size of the data and log files in the specified database.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql.md
@@ -32,7 +32,8 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC SHRINKFILE (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
+
 
 Shrinks the current database's specified data or log file size. You can use it to move data from one file to other files in the same filegroup, which empties the file and allows for its database removal. You can shrink a file to less than its size at creation, resetting the minimum file size to the new value.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-sqlperf-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-sqlperf-transact-sql.md
@@ -25,7 +25,8 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC SQLPERF (Transact-SQL)
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi.md)]
+
 
 Provides transaction log space usage statistics for all databases. In [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] it can also be used to reset wait and latch statistics.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-transact-sql.md
@@ -41,7 +41,7 @@ ms.author: umajay
 
 # DBCC (Transact-SQL)
 
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 The [!INCLUDE[tsql](../../includes/tsql-md.md)] programming language provides DBCC statements that act as Database Console Commands for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].
   
diff --git a/docs/t-sql/database-console-commands/dbcc-updateusage-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-updateusage-transact-sql.md
@@ -38,7 +38,7 @@ ms.author: umajay
 
 # DBCC UPDATEUSAGE (Transact-SQL)
 
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Reports and corrects pages and row count inaccuracies in the catalog views. These inaccuracies may cause incorrect space usage reports returned by the sp_spaceused system stored procedure.
   
diff --git a/docs/t-sql/database-console-commands/dbcc-useroptions-transact-sql.md b/docs/t-sql/database-console-commands/dbcc-useroptions-transact-sql.md
@@ -24,7 +24,7 @@ author: pmasl
 ms.author: umajay
 ---
 # DBCC USEROPTIONS (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Returns the SET options active (set) for the current connection.
   
