DX Unified Infrastructure Management

 View Only
  • 1.  sql_response probe and store procedures

    Posted Dec 03, 2019 11:53 AM
    Hello!!!

    I need some help with SQL_response probe. I tried to execute a store procedure but the test shows me the following error:

    "Profile: cmd_run_test, operation: open recordset, COM Error [0x800a0e78] Unknown error 0x800A0E78 - [ADODB.Recordset] Operation is not allowed when the object is closed."

    Can i put "exec store_procedure" in the Simple Query textbox? I think i can't but, can you confirm me that?

    Thanks !!!


  • 2.  RE: sql_response probe and store procedures

    Broadcom Employee
    Posted Dec 03, 2019 12:35 PM
    As far as I know, the queries must start with a select statement.

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: sql_response probe and store procedures
    Best Answer

    Posted Dec 03, 2019 12:44 PM
    you can use openquery

    select * from openquery(sql_conn, 'exec stored_procedure');