How to set a server dynamically in the SQL query?

[Former Member]

Hi all,

is there a possibility to create an SQL query without defining the DB server?

I have two ME databases and would like to use one and the same query for both of them. So in the transaction I will have to link only the Server parameter.

Thank you in advance!

Best Regards,

Elena _

[Former Member · Accepted solution]

Hi Elena,

Create the query object with any one server and then from the transaction override the name of the server using the Server parameter. It should work.

Otherwise create a blank query object and then pass all the necessary parameters like Server, Mode, Query etc from the transaction. This should also work.

Regards,

Rohit Negi.

[Former Member · Accepted solution]

Thank you very much!

Your advice was helpful