Devart Forums

Hello.

How can I run a long running stored procedure in asynchronous mode? In addition I want receive SQL Server prints during batch execution. I tried to use NonBlocking option of TMSQuery but execution was synchronous anyway

To execute a stored procedure in the asynchronous mode, use the TMSSQL component. Before calling the TMSSQL.Execute method, set the TMSSQL.NonBlocking property to True.

To retrieve SQL Server info messages in SDAC, you can use the TMSConnection.OnInfoMessage event handler. This event will be generated when executing a query with TMSQuery, TMSStoredProc. Refer our online documentation for more details about this event: https://www.devart.com/sdac/docs/#devar ... essage.htm

To learn how to implement asynchronous transfer of SQL Server info messages, read the MSDN blog: https://social.msdn.microsoft.com/Forum ... -displayed