SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software

Development Forums for Programmer, Administrators and Users

Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.

The statement 'PRINT' is not supported with natively compiled stored procedures.

Last post 10-22-2013, 1:54 PM by eralper. 0 replies.
Sort Posts:
  •  10-22-2013, 1:54 PM 37785

    The statement 'PRINT' is not supported with natively compiled stored procedures.

    If you are a SQL programmers writing stored procedures in SQL Server, and if you have already starting to work on SQL Server 2014, you will possible soon get the below error message:

    Msg 10794, Level 16, State 96, Procedure sp_InsertData2MemoryOptimizedTable, Line 82
    The statement 'PRINT' is not supported with natively compiled stored procedures.

    It is not a good way of using PRINT in ordinary SQL Server stored procedure, I know that. But sometimes, it helps me to debug an error or trace the flow in a stored procedure code.
    Unfortunately, SQL developers will not be able to use this method ( using PRINT ) in natively compiled stored procedures in SQL Server 2014.
View as RSS news feed in XML
Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems