more metadata changes

markingmyname · markingmyname · commit ae9805093a04 · 2022-01-14T16:08:38.000-06:00
diff --git a/docs/connect/jdbc/microsoft-jdbc-driver-for-sql-server.md b/docs/connect/jdbc/microsoft-jdbc-driver-for-sql-server.md
@@ -1,16 +1,15 @@
 ---
 title: Microsoft JDBC Driver for SQL Server
 description: Microsoft provides a JDBC driver for use with SQL Server and Azure SQL Database, enabling connectivity from any Java application, server, or applet.
-ms.custom: FY21Q2Fresh
-ms.date: 12/10/2021
 ms.prod: sql
 ms.prod_service: connectivity
-ms.reviewer: ""
 ms.technology: connectivity
 ms.topic: conceptual
-ms.assetid: baf420ab-c058-4cec-a673-d7cb6397210e
 author: David-Engel
 ms.author: v-davidengel
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: 12/10/2021
 ---
 # Microsoft JDBC Driver for SQL Server
 
diff --git a/docs/database-engine/configure-windows/change-server-authentication-mode.md b/docs/database-engine/configure-windows/change-server-authentication-mode.md
@@ -3,16 +3,15 @@ title: Change Server Authentication Mode
 description: Learn how to change the server authentication mode in SQL Server. You can use either SQL Server Management Studio or Transact-SQL for this task.
 ms.prod: sql
 ms.prod_service: high-availability
-ms.reviewer: ""
 ms.technology: configuration
 ms.topic: conceptual
 helpviewer_keywords: 
   - "sa account"
   - "authentication [SQL Server], changing modes"
   - "server authentication mode [SQL Server]"
   - "modifying server authentication mode"
-ms.assetid: 79babcf8-19fd-4495-b8eb-453dc575cac0
 author: markingmyname
+ms.reviewer: ""
 ms.author: maghan
 ms.custom: FY21Q2Fresh
 ms.date: 11/17/2021
diff --git a/docs/relational-databases/collations/collation-and-unicode-support.md b/docs/relational-databases/collations/collation-and-unicode-support.md
@@ -1,8 +1,6 @@
 ---
 title: Collation and Unicode support
 description: Learn about collation and Unicode support in SQL Server.
-ms.custom: FY21Q2Fresh
-ms.date: 12/10/2021
 ms.prod: sql
 ms.technology: 
 ms.topic: conceptual
@@ -29,9 +27,11 @@ helpviewer_keywords:
   - "UTF16"
   - "UCS2"
   - "server-level collations [SQL Server]"
-ms.assetid: 92d34f48-fa2b-47c5-89d3-a4c39b0f39eb
 author: "pmasl"
 ms.author: wiassaf
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: 12/10/2021
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 
diff --git a/docs/relational-databases/databases/rename-a-database.md b/docs/relational-databases/databases/rename-a-database.md
@@ -1,18 +1,18 @@
 ---
-description: "Rename a Database"
 title: "Rename a Database"
-ms.custom: FY21Q2Fresh
-ms.date: "10/21/2021"
+description: "Rename a Database"
 ms.prod: sql
 ms.prod_service: "database-engine"
-ms.reviewer: ""
 ms.technology: 
 ms.topic: conceptual
 helpviewer_keywords: 
   - "databases [SQL Server], renaming"
   - "renaming databases"
 author: WilliamDAssafMSFT
 ms.author: wiassaf
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: "10/21/2021"
 monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Rename a Database
diff --git a/docs/relational-databases/databases/set-a-database-to-single-user-mode.md b/docs/relational-databases/databases/set-a-database-to-single-user-mode.md
@@ -1,21 +1,23 @@
 ---
-description: "Set a database to single-user mode"
 title: "Set a database to single-user mode"
-ms.custom: FY21Q2Fresh
-ms.date: "10/21/2021"
+description: "Set a database to single-user mode"
 ms.prod: sql
 ms.prod_service: "database-engine"
-ms.reviewer: ""
 ms.technology: 
 ms.topic: conceptual
 helpviewer_keywords: 
   - "single-user mode [SQL Server], database option"
 author: WilliamDAssafMSFT
 ms.author: wiassaf
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: "10/21/2021"
 ---
 # Set a database to single-user mode
- [!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
-  This article describes how to set a user-defined database to single-user mode in [!INCLUDE[ssnoversion](../../includes/ssnoversion-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)]. Single-user mode specifies that only one user at a time can access the database and is generally used for maintenance actions.  
+
+[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+
+This article describes how to set a user-defined database to single-user mode in [!INCLUDE[ssnoversion](../../includes/ssnoversion-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)]. Single-user mode specifies that only one user at a time can access the database and is generally used for maintenance actions.  
   
 ##  <a name="Restrictions"></a> Limitations and restrictions  
   
diff --git a/docs/relational-databases/databases/view-a-list-of-databases-on-an-instance-of-sql-server.md b/docs/relational-databases/databases/view-a-list-of-databases-on-an-instance-of-sql-server.md
@@ -1,7 +1,6 @@
 ---
 title: "View list of databases on SQL Server"
 description: Learn how to view a list of databases on an instance of SQL Server by using SQL Server Management Studio or Transact-SQL.
-ms.date: "10/21/2021"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
 ms.reviewer: ""
@@ -18,12 +17,16 @@ helpviewer_keywords:
   - "listing databases"
 author: WilliamDAssafMSFT
 ms.author: wiassaf
-monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ms.custom: "seo-lt-2019, FY21Q2Fresh"
+ms.date: "10/21/2021"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# View list of databases on SQL Server     
+
+# View list of databases on SQL Server
+
 [!INCLUDE [SQL Server Azure SQL Database](../../includes/applies-to-version/sql-asdb.md)]
-  This article describes how to view a list of databases on an instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)].  
+
+This article describes how to view a list of databases on an instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)].  
  
 ## <a name="Security"></a><a name="Permissions"></a> Permissions  
  If the caller of `sys.databases` is not the owner of the database and the database is not `master` or `tempdb`, the minimum permissions required to see the corresponding row are ALTER ANY DATABASE or VIEW ANY DATABASE server-level permission, or CREATE DATABASE permission in the `master` database. The database to which the caller is connected can always be viewed in `sys.databases`.  
diff --git a/docs/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database.md b/docs/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database.md
@@ -1,11 +1,8 @@
 ---
 title: "View or Change the Compatibility Level of a Database"
 description: Learn how to view or change the compatibility level of a database in SQL Server by using SQL Server Management Studio or Transact-SQL.
-ms.custom: FY21Q2Fresh
-ms.date: "10/21/2021"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
-ms.reviewer: ""
 ms.technology: supportability
 ms.topic: conceptual
 helpviewer_keywords: 
@@ -14,15 +11,20 @@ helpviewer_keywords:
   - "compatibility levels [SQL Server], changing"
 author: WilliamDAssafMSFT
 ms.author: wiassaf
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: "10/21/2021"
 monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # View or change the compatibility level of a database
+
 [!INCLUDE [SQL Server Azure SQL Database](../../includes/applies-to-version/sql-asdb.md)]
-  This article describes how to view or change the compatibility level of a database in [!INCLUDE[ssnoversion](../../includes/ssnoversion-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)]. 
+
+This article describes how to view or change the compatibility level of a database in [!INCLUDE[ssnoversion](../../includes/ssnoversion-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)]. 
 
 > [!IMPORTANT]
 > Before you change the compatibility level of a database, you should understand the impact of the change on your applications. For more information, see [ALTER DATABASE Compatibility Level &#40;Transact-SQL&#41;](../../t-sql/statements/alter-database-transact-sql-compatibility-level.md).  
-    
+
 ## <a name="Security"></a><a name="Permissions"></a> Permissions  
  Requires ALTER permission on the database.  
   
diff --git a/docs/relational-databases/indexes/clustered-and-nonclustered-indexes-described.md b/docs/relational-databases/indexes/clustered-and-nonclustered-indexes-described.md
@@ -1,19 +1,18 @@
 ---
-description: "Clustered and nonclustered indexes described"
 title: "Clustered and nonclustered indexes described"
-ms.custom: FY21Q2Fresh
-ms.date: 10/25/2021
+description: "Clustered and nonclustered indexes described"
 ms.prod: sql
 ms.prod_service: "table-view-index, sql-database"
-ms.reviewer: ""
 ms.technology: table-view-index
 ms.topic: conceptual
 helpviewer_keywords: 
   - "query optimizer [SQL Server], index usage"
   - "index concepts [SQL Server]"
-ms.assetid: b7d6b323-728d-4763-a987-92e6292f6f7a
 author: MikeRayMSFT
 ms.author: mikeray
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: 10/25/2021
 monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Clustered and nonclustered indexes described
diff --git a/docs/relational-databases/indexes/create-nonclustered-indexes.md b/docs/relational-databases/indexes/create-nonclustered-indexes.md
@@ -1,11 +1,8 @@
 ---
+title: Create Nonclustered Indexes
 description: "Create Nonclustered Indexes"
-title: "Create Nonclustered Indexes | Microsoft Docs"
-ms.custom: FY21Q2Fresh
-ms.date: 11/12/2021
 ms.prod: sql
 ms.prod_service: "table-view-index, sql-database"
-ms.reviewer: ""
 ms.technology: table-view-index
 ms.topic: conceptual
 helpviewer_keywords: 
@@ -17,12 +14,16 @@ helpviewer_keywords:
 ms.assetid: 9402029a-1227-46c4-93aa-c2122eb1b943
 author: MikeRayMSFT
 ms.author: mikeray
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: 11/12/2021
 monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Create Nonclustered Indexes
+
 [!INCLUDE [SQL Server Azure SQL Database](../../includes/applies-to-version/sql-asdb.md)]
 
-  You can create nonclustered indexes in [!INCLUDE[ssnoversion](../../includes/ssnoversion-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)]. A nonclustered index is an index structure separate from the data stored in a table that reorders one or more selected columns. Nonclustered indexes can often help you find data more quickly than searching the underlying table; queries can sometimes be answered entirely by the data in the nonclustered index, or the nonclustered index can point the [!INCLUDE[ssDE](../../includes/ssde-md.md)] to the rows in the underlying table. Generally, nonclustered indexes are created to improve the performance of frequently used queries not covered by the clustered index or to locate rows in a table without a clustered index (called a heap). You can create multiple nonclustered indexes on a table or indexed view.  
+You can create nonclustered indexes in [!INCLUDE[ssnoversion](../../includes/ssnoversion-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)]. A nonclustered index is an index structure separate from the data stored in a table that reorders one or more selected columns. Nonclustered indexes can often help you find data more quickly than searching the underlying table; queries can sometimes be answered entirely by the data in the nonclustered index, or the nonclustered index can point the [!INCLUDE[ssDE](../../includes/ssde-md.md)] to the rows in the underlying table. Generally, nonclustered indexes are created to improve the performance of frequently used queries not covered by the clustered index or to locate rows in a table without a clustered index (called a heap). You can create multiple nonclustered indexes on a table or indexed view.  
   
 ##  <a name="BeforeYouBegin"></a> Before You Begin  
   
diff --git a/docs/relational-databases/performance/view-the-sql-server-error-log-sql-server-management-studio.md b/docs/relational-databases/performance/view-the-sql-server-error-log-sql-server-management-studio.md
@@ -1,10 +1,7 @@
 ---
 title: "View the SQL Server error log (SSMS)"
 description: Learn about the SQL Server error log, which contains user-defined events and certain system events you can use for troubleshooting.
-ms.custom: seo-dt-2019, FY21Q2Fresh
-ms.date: "10/21/2021"
 ms.prod: sql
-ms.reviewer: ""
 ms.technology: performance
 ms.topic: conceptual
 helpviewer_keywords: 
@@ -15,6 +12,9 @@ helpviewer_keywords:
   - "logs [SQL Server], viewing"
 author: WilliamDAssafMSFT
 ms.author: wiassaf
+ms.reviewer: ""
+ms.custom: seo-dt-2019, FY21Q2Fresh
+ms.date: "10/21/2021"
 ---
 # View the SQL Server error log in SQL Server Management Studio (SSMS)
 
diff --git a/docs/relational-databases/security/authentication-access/database-level-roles.md b/docs/relational-databases/security/authentication-access/database-level-roles.md
@@ -1,11 +1,8 @@
 ---
 title: "Database-Level Roles"
 description: SQL Server provides several roles that are security principals that group other principals to manage the permissions in your databases.
-ms.custom: FY21Q2Fresh
-ms.date: 12/16/2021
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, azure-synapse, pdw"
-ms.reviewer: ""
 ms.technology: security
 ms.topic: conceptual
 f1_keywords: 
@@ -37,6 +34,9 @@ helpviewer_keywords:
   - "groups [SQL Server], roles"
 author: VanMSFT
 ms.author: vanto
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: 12/16/2021
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Database-level roles
diff --git a/docs/relational-databases/stored-procedures/create-a-stored-procedure.md b/docs/relational-databases/stored-procedures/create-a-stored-procedure.md
@@ -16,6 +16,7 @@ ms.author: wiassaf
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Create a stored procedure
+
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
 
diff --git a/docs/relational-databases/stored-procedures/modify-a-stored-procedure.md b/docs/relational-databases/stored-procedures/modify-a-stored-procedure.md
@@ -1,10 +1,7 @@
 ---
 title: "Modify a Stored Procedure"
 description: Learn how to modify a stored procedure in SQL Server by using SQL Server Management Studio or Transact-SQL.
-ms.custom: FY21Q2Fresh
-ms.date: "10/21/2021"
 ms.prod: sql
-ms.reviewer: ""
 ms.technology: stored-procedures
 ms.topic: conceptual
 helpviewer_keywords: 
@@ -13,11 +10,15 @@ helpviewer_keywords:
   - "stored procedures [SQL Server], modifying"
 author: WilliamDAssafMSFT
 ms.author: wiassaf
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: "10/21/2021"
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
+
 # Modify a Stored Procedure
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
-    
+
 <a name="Top"></a> This article describes how to modify a stored procedure in [!INCLUDE[ssnoversion](../../includes/ssnoversion-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)]. 
   
 ##  <a name="Restrictions"></a> Limitations and restrictions  
diff --git a/docs/relational-databases/stored-procedures/return-data-from-a-stored-procedure.md b/docs/relational-databases/stored-procedures/return-data-from-a-stored-procedure.md
@@ -1,18 +1,17 @@
 ---
 title: "Return data from a stored procedure"
 description: Learn how to return data from a procedure to a calling program by using result sets, output parameters, and return codes.
-ms.custom: FY21Q2Fresh
-ms.date: "12/15/2021"
 ms.prod: sql
 ms.technology: stored-procedures
-ms.reviewer: ""
 ms.topic: conceptual
 helpviewer_keywords: 
   - "stored procedures [SQL Server], returning data"
   - "returning data from stored procedure"
-ms.assetid: 7a428ffe-cd87-4f42-b3f1-d26aa8312bf7
 author: WilliamDAssafMSFT
 ms.author: wiassaf
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: "12/15/2021"
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Return data from a stored procedure
diff --git a/docs/relational-databases/tables/create-foreign-key-relationships.md b/docs/relational-databases/tables/create-foreign-key-relationships.md
@@ -1,22 +1,21 @@
 ---
-description: "Create Foreign Key Relationships"
 title: "Create Foreign Key Relationships"
-ms.custom: FY21Q2Fresh
-ms.date: "12/20/2021"
+description: "Create Foreign Key Relationships"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
-ms.reviewer: "vanto"
 ms.technology: table-view-index
 ms.topic: conceptual
 helpviewer_keywords: 
   - "relationships [SQL Server], creating"
 author: WilliamDAssafMSFT
 ms.author: wiassaf
+ms.reviewer: "vanto"
+ms.custom: FY21Q2Fresh
+ms.date: "12/20/2021"
 monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Create Foreign Key Relationships
 
-
 [!INCLUDE [sqlserver2016-asdb-asdbmi](../../includes/applies-to-version/sqlserver2016-asdb-asdbmi.md)]
 
 This article describes how to create foreign key relationships in [!INCLUDE[ssnoversion](../../includes/ssnoversion-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)]. You create a relationship between two tables when you want to associate rows of one table with rows of another.
diff --git a/docs/relational-databases/tables/create-primary-keys.md b/docs/relational-databases/tables/create-primary-keys.md
@@ -1,18 +1,17 @@
 ---
-description: "Create Primary Keys"
 title: "Create Primary Keys in SQL Server"
-ms.custom: FY21Q2Fresh
-ms.date: 10/25/2021
+description: "Create Primary Keys"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
-ms.reviewer: ""
 ms.technology: table-view-index
 ms.topic: conceptual
 helpviewer_keywords: 
   - "primary keys [SQL Server], creating"
-ms.assetid: 85c623ca-4656-4d70-a9db-ee4d897cd214
 author: WilliamDAssafMSFT
 ms.author: wiassaf
+ms.reviewer: ""
+ms.custom: FY21Q2Fresh
+ms.date: 10/25/2021
 monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Create Primary Keys
diff --git a/docs/relational-databases/tables/delete-columns-from-a-table.md b/docs/relational-databases/tables/delete-columns-from-a-table.md
diff --git a/docs/relational-databases/tables/modify-columns-database-engine.md b/docs/relational-databases/tables/modify-columns-database-engine.md
diff --git a/docs/relational-databases/tables/primary-and-foreign-key-constraints.md b/docs/relational-databases/tables/primary-and-foreign-key-constraints.md
diff --git a/docs/relational-databases/tables/rename-columns-database-engine.md b/docs/relational-databases/tables/rename-columns-database-engine.md
diff --git a/docs/relational-databases/tables/specify-computed-columns-in-a-table.md b/docs/relational-databases/tables/specify-computed-columns-in-a-table.md
diff --git a/docs/relational-databases/tables/specify-default-values-for-columns.md b/docs/relational-databases/tables/specify-default-values-for-columns.md
diff --git a/docs/samples/adventureworks-install-configure.md b/docs/samples/adventureworks-install-configure.md
diff --git a/docs/sql-server/index.yml b/docs/sql-server/index.yml
