TechNet
Export (0) Print
Expand All

SQL Server Message Results

 

System_CAPS_ICON_warning.jpg Warning

SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. Avoid using SNAC in new development work, and plan to modify applications that currently use it. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database.

The following Transact-SQL statements do not generate SQL Server 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 SQL Server to return informational messages in place of rowset or count results. On successful execution, the SQL Server Native Client OLE DB provider returns S_OK, and the messages are available to the SQL Server Native Client OLE DB provider consumer.

The SQL Server Native Client OLE DB provider returns S_OK and has one or more informational messages available following the execution of many Transact-SQL statements or the consumer execution of a SQL Server Native Client OLE DB provider member function.

The SQL Server 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.

Errors

Community Additions

ADD
Show:
© 2016 Microsoft