# Getting data from Ignition stored procedure call but not in SSMS?

**URL:** <https://forum.inductiveautomation.com/t/getting-data-from-ignition-stored-procedure-call-but-not-in-ssms/68804>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [January 19, 2023, 5:21pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-ignition-stored-procedure-call-but-not-in-ssms/68804 "2023-01-19T17:21:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [January 19, 2023, 5:21pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-ignition-stored-procedure-call-but-not-in-ssms/68804/1 "2023-01-19T17:21:37Z")

</div>

Testing my rewrites of some stored procedures to make sure every combination of parameters leads to the same outputs as the original.

Experiencing a weird issue in testing. Sometimes I am testing in SSMS and some error message comes up (for both the original and rewrite). I can't see the result set.

But then running the stored procedures using `system.db.*` and using `.getResultSet()` I do see something. I assume there is some minor error suppression or something I can run in my SSMS to mirror this but I don't know what it is and did not expect this difference in behavior. Anyone know what could cause this and how to make it so I still see the result set in sql server (since one is being served back to Ignition at least despite I assume the same errors happening).