This doesn’t currently seem possible so thought I would raise it as an idea to see if it is able to be implemented.

In a nutshell, it is requesting a way to capture the same output you see in the “Messages” tab of SQL Server Management Studio, when firing off a SQL Stored Procedure using the SQLExecutor function in FME.

Using an example to help explain this:

There is a SQL stored procedure which, when run in SQL Server Management Studio, outputs a lot of PRINT statements to the “Messages” tab (highlighted below), which are really useful for troubleshooting the procedure if there are any issues encountered when running.  And also useful for seeing exactly what has run.  When this stored procedure is run using SQLExecutor in FME, although I have logging (including at debug level) in FME, it doesn’t capture these PRINT outputs, or any of the SQL queries that run for that matter.  An example of the output I am referring to is below (from SQL Server Management Studio).

It would be really useful to capture this information in a log file/transaction log, so there can be a check each morning to see if any errors have occurred in the SQL stored procedure that has run overnight.  In some cases where the workspace completes successfully, but the SQL stored procedure does not, the log would show as completing successfuly but there wouldn’t be any indication in the FME log that there was an issue with the SQL stored procedure, i.e., it seems that everything has completed successfully when it actually hasn’t.

The ability to capture this output from SQL Server would be very useful.