Merge branch 'master' of https://github.com/MicrosoftDocs/sql-docs-pr

TimShererWithAquent · TimShererWithAquent · commit 817832f03de6 · 2020-07-27T09:00:39.000-07:00
diff --git a/docs/ado/guide/data/error-handling.md b/docs/ado/guide/data/error-handling.md
@@ -15,7 +15,7 @@ ms.assetid: 4909e413-f3b0-4183-8ad3-67b1434df742
 author: rothja
 ms.author: jroth
 ---
-# Error Handling
+# Error Handling in ADO
 ADO uses several different methods to notify an application of errors that occur. This section discusses the types of errors that can occur when you are using ADO and how your application is notified. It concludes by making suggestions about how to handle those errors.  
   
 ## How Does ADO Report Errors?  
diff --git a/docs/relational-databases/databases/database-instant-file-initialization.md b/docs/relational-databases/databases/database-instant-file-initialization.md
@@ -2,7 +2,7 @@
 title: Database Instant File Initialization
 description: Learn about instant file initialization and how to enable it on your SQL Server database.
 ms.custom: contperfq4
-ms.date: 05/30/2020
+ms.date: 07/24/2020
 ms.prod: sql
 ms.prod_service: "database-engine"
 ms.reviewer: ""
@@ -32,6 +32,7 @@ By default, data and log files are initialized to overwrite any existing data le
 
 In [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], instant file initialization (IFI) allows for faster execution of the previously mentioned file operations, since it reclaims used disk space without filling that space with zeros. Instead, disk content is overwritten as new data is written to the files. Log files cannot be initialized instantaneously.
 
+
 ## Enable instant file initialization
 
 Instant file initialization is only available if the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] service startup account has been granted *SE_MANAGE_VOLUME_NAME*. Members of the Windows Administrator group have this right and can grant it to other users by adding them to the **Perform Volume Maintenance Tasks** security policy.  
@@ -93,5 +94,29 @@ If the potential for disclosing deleted content is a concern, you should take on
     > [!NOTE]
     > Disabling will increase allocation times  for data files, and only affects files that are created or increased in size after the user right is revoked.
   
+### SE_MANAGE_VOLUME_NAME user right
+
+The *SE_MANAGE_VOLUME_NAME* user privilege can be assigned in **Windows Administrative Tools**, **Local Security Policy** applet. Under **Local Policies** select **User Right Assignment** and modify the **Perform volume maintenance tasks** property.
+
+## Performance considerations
+
+The Database File initialization process writes zeros to the new regions of the file under initialization. The duration of this process  depends on size of file portion that is initialized and on the response time and capacity of the storage system. If the initialization takes a long time, you may see the following messages recorded in the SQL Server Errorlog and the Application Log.
+
+```
+Msg 5144
+Autogrow of file '%.*ls' in database '%.*ls' was cancelled by user or timed out after %d milliseconds.  Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
+```
+
+```
+Msg 5145
+Autogrow of file '%.*ls' in database '%.*ls' took %d milliseconds.  Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
+```
+
+A long autogrow of a database and/or transaction log file may cause query performance problems. This is because an operation that requires the autogrowth of a file will hold on to resources such as locks or latches during the duration of the file grow operation. You may see long waits on latches for allocation pages. The operation that requires the long autogrow will show a wait type of  PREEMPTIVE_OS_WRITEFILEGATHER.
+
+
+
+
+
 ## See Also  
  [CREATE DATABASE &#40;SQL Server Transact-SQL&#41;](../../t-sql/statements/create-database-sql-server-transact-sql.md)
diff --git a/docs/relational-databases/native-client-ole-db-blobs/blobs-and-ole-objects.md b/docs/relational-databases/native-client-ole-db-blobs/blobs-and-ole-objects.md
@@ -18,7 +18,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# BLOBs and OLE Objects
+# BLOBs and OLE Objects in SQL Server Native Client
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   The [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client OLE DB provider exposes the **ISequentialStream** interface to support consumer access to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] **ntext**, **text**, **image**, **varchar(max)**, **nvarchar(max)**, **varbinary(max)**, and xml data types as binary large objects (BLOBs). The **Read** method on **ISequentialStream** lets the consumer retrieve much data in manageable chunks.  
diff --git a/docs/relational-databases/native-client-ole-db-data-types/data-type-mapping-in-itabledefinition.md b/docs/relational-databases/native-client-ole-db-data-types/data-type-mapping-in-itabledefinition.md
@@ -20,7 +20,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Data Type Mapping in ITableDefinition
+# SQL Server Native Client Data Type Mapping in ITableDefinition
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   When creating tables by using the **ITableDefinition::CreateTable** function, the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client OLE DB provider consumer can specify [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] data types in the *pwszTypeName* member of the DBCOLUMNDESC array that is passed. If the consumer specifies the data type of a column by name, OLE DB data type mapping, represented by the *wType* member of the DBCOLUMNDESC structure, is ignored.  
diff --git a/docs/relational-databases/native-client-ole-db-data-types/data-type-mapping-in-rowsets-and-parameters.md b/docs/relational-databases/native-client-ole-db-data-types/data-type-mapping-in-rowsets-and-parameters.md
@@ -23,7 +23,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Data Type Mapping in Rowsets and Parameters
+# SQL Server Native Client Data Type Mapping in Rowsets and Parameters
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   In rowsets and as parameter values, the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client OLE DB provider represents [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] data by using the following OLE DB defined data types, reported in the functions **IColumnsInfo::GetColumnInfo** and **ICommandWithParameters::GetParameterInfo**.  
diff --git a/docs/relational-databases/native-client-ole-db-data-types/data-types-ole-db.md b/docs/relational-databases/native-client-ole-db-data-types/data-types-ole-db.md
@@ -17,7 +17,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Data Types (OLE DB)
+# SQL Server Native Client Data Types (OLE DB)
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   In order to execute [!INCLUDE[tsql](../../includes/tsql-md.md)] statements and process the results using the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client OLE DB provider, you must know how the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client OLE DB provider maps [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] data types to OLE DB data types when binding parameters or columns in a rowset, and when it uses the **ITableDefinition** interface to create a table in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].  
diff --git a/docs/relational-databases/native-client-ole-db-date-time/data-type-support-for-ole-db-date-and-time-improvements.md b/docs/relational-databases/native-client-ole-db-date-time/data-type-support-for-ole-db-date-and-time-improvements.md
@@ -16,7 +16,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Data Type Support for OLE DB Date and Time Improvements
+# SQL Server Native Client Data Type Support for OLE DB Date and Time Improvements
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   This topic provides information about OLE DB ( [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client) types that support [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] date/time data types.  
diff --git a/docs/relational-databases/native-client-ole-db-date-time/date-and-time-improvements-ole-db.md b/docs/relational-databases/native-client-ole-db-date-time/date-and-time-improvements-ole-db.md
@@ -16,7 +16,7 @@ ms.author: maghan
 ms.custom: seo-dt-2019
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Date and Time Improvements (OLE DB)
+# SQL Server Native Client Date and Time Improvements (OLE DB)
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   [!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] introduces new date and time data types. This section describes how these new types are exposed as extensions in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client. For an overview of the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client support for the new date and time data types, see [Date and Time Improvements](../../relational-databases/native-client/features/date-and-time-improvements.md). For a sample, see [Use Enhanced Date and Time Features &#40;OLE DB&#41;](../../relational-databases/native-client-ole-db-how-to/use-enhanced-date-and-time-features-ole-db.md).  
diff --git a/docs/relational-databases/native-client-ole-db-errors/errors.md b/docs/relational-databases/native-client-ole-db-errors/errors.md
@@ -18,7 +18,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Errors
+# SQL Server Native Client Errors
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   OLE/COM objects report errors through the HRESULT return code of object member functions. An OLE/COM HRESULT is a bit-packed structure. OLE provides macros that dereference structure members.  
diff --git a/docs/relational-databases/native-client-ole-db-how-to/bulk-copy-data-using-irowsetfastload-ole-db.md b/docs/relational-databases/native-client-ole-db-how-to/bulk-copy-data-using-irowsetfastload-ole-db.md
@@ -17,7 +17,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Bulk Copy Data Using IRowsetFastLoad (OLE DB)
+# Bulk Copy Data Using IRowsetFastLoad (OLE DB) in  SQL Server Native Client
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   This sample shows the use of IRowsetFastLoad for bulk copying of records into a table.  
diff --git a/docs/relational-databases/native-client-ole-db-how-to/change-a-sql-server-authentication-user-password-ole-db.md b/docs/relational-databases/native-client-ole-db-how-to/change-a-sql-server-authentication-user-password-ole-db.md
@@ -12,7 +12,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Change a SQL Server Authentication User Password (OLE DB)
+# Change a SQL Server Native Client Authentication User Password (OLE DB)
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   This sample shows how to use OLE DB to change the password of a user account under [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Authentication.  
diff --git a/docs/relational-databases/native-client-ole-db-how-to/display-column-and-catalog-metadata-for-sparse-columns-ole-db.md b/docs/relational-databases/native-client-ole-db-how-to/display-column-and-catalog-metadata-for-sparse-columns-ole-db.md
@@ -12,7 +12,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Display Column and Catalog Metadata for Sparse Columns (OLE DB)
+# SQL Server Native Client Display Column and Catalog Metadata for Sparse Columns (OLE DB)
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   This sample creates a table with three columns: a sparse column, a column that is not a sparse column, and a columnset column. The sample then displays OLE DB flags showing the column and catalog metadata for the non-sparse column and the columnset column.  
diff --git a/docs/relational-databases/native-client-ole-db-how-to/enumerate-ole-db-data-sources-ole-db.md b/docs/relational-databases/native-client-ole-db-how-to/enumerate-ole-db-data-sources-ole-db.md
@@ -14,7 +14,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Enumerate OLE DB Data Sources (OLE DB)
+# Enumerate SQL Server Native Client OLE DB Data Sources (OLE DB)
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   This sample shows how to use the enumerator object to list the data sources available.  
diff --git a/docs/relational-databases/native-client-ole-db-how-to/fetch-columns-using-irow-getcolumns-ole-db.md b/docs/relational-databases/native-client-ole-db-how-to/fetch-columns-using-irow-getcolumns-ole-db.md
@@ -14,7 +14,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Fetch Columns Using IRow::GetColumns (OLE DB)
+# Fetch Columns in SQL Server Native Client Using IRow::GetColumns (OLE DB)
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   The **IRow** interface allows direct access to columns of a single row in the result set. Thus, **IRow** is an efficient way to retrieve columns from a result set with one row.  
diff --git a/docs/relational-databases/native-client-ole-db-how-to/results/execute-a-user-defined-function-and-process-return-code-ole-db.md b/docs/relational-databases/native-client-ole-db-how-to/results/execute-a-user-defined-function-and-process-return-code-ole-db.md
@@ -14,7 +14,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Execute a User-Defined Function and Process Return Code (OLE DB)
+# Execute a SQL Server Native Client User-Defined Function and Process Return Code (OLE DB)
 [!INCLUDE [SQL Server](../../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   In this example, a user-defined function is executed, and the return code is printed. This sample is not supported on IA64.  
diff --git a/docs/relational-databases/native-client-ole-db-how-to/results/execute-stored-procedure-with-odbc-call-and-process-output.md b/docs/relational-databases/native-client-ole-db-how-to/results/execute-stored-procedure-with-odbc-call-and-process-output.md
@@ -15,7 +15,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Execute Stored Procedure with ODBC CALL and Process Output
+# Execute SQL Server Native Client Stored Procedure with ODBC CALL and Process Output
 [!INCLUDE [SQL Server](../../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] stored procedures can have integer return codes and output parameters. The return codes and output parameters are sent in the last packet from the server and are therefore not available to the application until the rowset is completely released. If the command returns multiple results, output parameter data is available when **IMultipleResults::GetResult** returns DB_S_NORESULT or the **IMultipleResults** interface is completely released, whichever occurs first.  
diff --git a/docs/relational-databases/native-client-ole-db-how-to/results/execute-stored-procedure-with-rpc-and-process-output.md b/docs/relational-databases/native-client-ole-db-how-to/results/execute-stored-procedure-with-rpc-and-process-output.md
@@ -15,7 +15,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Execute Stored Procedure with RPC and Process Output
+# Execute SQL Server Native Client Stored Procedure with RPC and Process Output
 [!INCLUDE [SQL Server](../../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] stored procedures can have integer return codes and output parameters. The return codes and output parameters are sent in the last packet from the server and are therefore not available to the application until the rowset is completely released. If the command returns multiple results, output parameter data is available when **IMultipleResults::GetResult** returns DB_S_NORESULT, or when the **IMultipleResults** interface is completely released, whichever occurs first.  
diff --git a/docs/relational-databases/native-client-ole-db-provider/about-ole-db-properties.md b/docs/relational-databases/native-client-ole-db-provider/about-ole-db-properties.md
@@ -17,7 +17,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# About OLE DB Properties
+# About SQL Server Native Client OLE DB Properties
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   Consumers set property values to request specific object behavior. For example, consumers use properties to specify the interfaces to be exposed by a rowset. Consumers get the property values to determine the capabilities of an object, such as a rowset, a session, or a data source object.  
diff --git a/docs/relational-databases/native-client-ole-db-provider/establishing-a-connection-to-a-data-source.md b/docs/relational-databases/native-client-ole-db-provider/establishing-a-connection-to-a-data-source.md
@@ -18,7 +18,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Establishing a Connection to a Data Source
+# Establishing a Connection to a SQL Server Native Client Data Source
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   To access the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client OLE DB provider, the consumer must first create an instance of a data source object by calling the **CoCreateInstance** method. A unique class identifier (CLSID) identifies each OLE DB provider. For the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client OLE DB provider, the class identifier is CLSID_SQLNCLI10. You can also use the symbol SQLNCLI_CLSID that will resolve to the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Native Client OLE DB provider that is used in the sqlncli.h that you reference.  
diff --git a/docs/relational-databases/native-client-ole-db-provider/executing-a-command.md b/docs/relational-databases/native-client-ole-db-provider/executing-a-command.md
@@ -18,7 +18,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Executing a Command
+# Executing a SQL Server Native Client Command
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   After the connection to a data source is established, the consumer calls the **IDBCreateSession::CreateSession** method to create a session. The session acts as a command, rowset, or transaction factory.  
diff --git a/docs/relational-databases/native-client-ole-db-rowsets/bookmarks.md b/docs/relational-databases/native-client-ole-db-rowsets/bookmarks.md
@@ -17,7 +17,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Bookmarks
+# Bookmarks in SQL Server Native Client
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   Bookmarks let consumers quickly return to a row. With bookmarks, consumers can access rows randomly based on the bookmark value. The bookmark column is column 0 in the rowset. The consumer sets the dwFlag field value of the binding structure to DBCOLUMNSINFO_ISBOOKMARK to indicate that the column is used as a bookmark. The consumer also sets the rowset property DBPROP_BOOKMARKS to VARIANT_TRUE. This lets column 0 be present in the rowset. The **IRowsetLocate::GetRowsAt** method is then used to fetch rows, starting with the row specified as an offset from a bookmark.  
diff --git a/docs/relational-databases/native-client-ole-db-table-valued-parameters/executing-commands-containing-table-valued-parameters.md b/docs/relational-databases/native-client-ole-db-table-valued-parameters/executing-commands-containing-table-valued-parameters.md
@@ -14,7 +14,7 @@ author: markingmyname
 ms.author: maghan
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
-# Executing Commands Containing Table-Valued Parameters
+# Executing SQL Server Native Client Commands Containing Table-Valued Parameters
 [!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
   Executing a command that contains table-valued parameters requires two phases:  
diff --git a/docs/relational-databases/native-client-ole-db-tables-indexes/adding-a-column-to-a-sql-server-table.md b/docs/relational-databases/native-client-ole-db-tables-indexes/adding-a-column-to-a-sql-server-table.md
diff --git a/docs/relational-databases/native-client-ole-db-tables-indexes/dropping-a-sql-server-index.md b/docs/relational-databases/native-client-ole-db-tables-indexes/dropping-a-sql-server-index.md
diff --git a/docs/relational-databases/native-client-ole-db-tables-indexes/dropping-a-sql-server-table.md b/docs/relational-databases/native-client-ole-db-tables-indexes/dropping-a-sql-server-table.md
diff --git a/docs/relational-databases/native-client/features/accessing-diagnostic-information-in-the-extended-events-log.md b/docs/relational-databases/native-client/features/accessing-diagnostic-information-in-the-extended-events-log.md
diff --git a/docs/relational-databases/native-client/features/changing-passwords-programmatically.md b/docs/relational-databases/native-client/features/changing-passwords-programmatically.md
diff --git a/docs/relational-databases/native-client/features/date-and-time-improvements.md b/docs/relational-databases/native-client/features/date-and-time-improvements.md
diff --git a/docs/t-sql/statements/alter-external-language-transact-sql.md b/docs/t-sql/statements/alter-external-language-transact-sql.md
diff --git a/docs/t-sql/statements/drop-external-language-transact-sql.md b/docs/t-sql/statements/drop-external-language-transact-sql.md
