cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Proper information in Log window when executing SQL query

What inspired this wish list request?

 

JMP expects an actual table to be returned in a SQL query. So, if the SQL query contains create temp table, we must add "SET NOCOUNT ON" so the Transact-SQL statement does not try to return the rows impacted by the query. If there is not this line in the beginning of the SQL query, JMP just can't return any result and there is not any meaningful feedback in GUI or Log window.

 

 

What is the improvement you would like to see? 

Add meaningful feedback in GUI or Log window.

 

Why is this idea important? 

We need to have a proper response for any implementation, right?

 

 

1 Comment
Status changed to: Acknowledged

Thank you for taking the time to share this feedback!