Ranorex Forum

Currently I'm trying to use SQL Management Studio to validate a value in our database. So i've recorded a few steps in Ranorex to run the Management Studio and go into the correct folder where the stored procedures are etc.

The item (stored procedure) I want to click is in the Object Explorer of the Management Studio but it is not viewable. You would have to scroll to find the item. So I thought about using an Invoke Action Select but this one does not find the item in the list.

Is there another way or do you really have to use a scroll action?

Are you validating the MSSQL Stored Procedure (SP) itself, or are you using the SP to validate an item in your SUT?

You say you are validating a value in the DB, but then go on to talk about the SP, so not sure exactly what you are trying to do.

If the first, can you not just call the SP from .NET code in your test and check that the results are correct?

If the second, can you not just call the SP from .NET code in your test (see a pattern here? ) and check that the results match the SUT?


You can create a SQL data connector in Ranorex and call the SP from there, which would be the easiest way, if you don't need any special processing or parameterization of the SQL statement.

I wrote some .NET code and it works now, thanks for the tip