Skip to content

sql-server-message-results.md

Latest commit

 

History

History
39 lines (27 loc) · 2.26 KB

sql-server-message-results.md

File metadata and controls

39 lines (27 loc) · 2.26 KB
title SQL Server message results (Native Client OLE DB provider)
description SQL Server Native Client Message Results
author markingmyname
ms.author maghan
ms.date 03/14/2017
ms.service sql
ms.subservice native-client
ms.topic reference
helpviewer_keywords
SQL Server Native Client OLE DB provider, errors
errors [OLE DB], SQL Server message results
OLE DB error handling, SQL Server message results

SQL Server Native Client Message Results

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]

The following [!INCLUDEtsql] statements do not generate [!INCLUDEssNoVersion] Native Client OLE DB provider rowsets or a count of affected rows when executed:

  • PRINT

  • RAISERROR with a severity of 10 or lower

  • DBCC

  • SET SHOWPLAN

  • SET STATISTICS

These statements either return one or more informational messages or cause [!INCLUDEssNoVersion] to return informational messages in place of rowset or count results. On successful execution, the [!INCLUDEssNoVersion] Native Client OLE DB provider returns S_OK, and the messages are available to the [!INCLUDEssNoVersion] Native Client OLE DB provider consumer.

The [!INCLUDEssNoVersion] Native Client OLE DB provider returns S_OK and has one or more informational messages available following the execution of many [!INCLUDEtsql] statements or the consumer execution of a [!INCLUDEssNoVersion] Native Client OLE DB provider member function.

The [!INCLUDEssNoVersion] Native Client OLE DB provider consumer allowing dynamic specification of query text should check error interfaces after every member function execution regardless of the value of the return code, the presence or absence of a returned IRowset or IMultipleResults interface reference, or a count of affected rows.

See Also

Errors