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).