You might have to submit statements to a remote instance of Microsoft SQL Server when you want an action to occur on the SQL Server at the time of the RDA pull or push.

When you have a direct connection to the SQL Server, we recommend that you use sqlclient to run statements on the server. However, if you connect to the SQL Server through HTTP, you use SubmitSQL. SubmitSQL should only be used when you have to run a statement such as a stored procedure but do not need the data returned.

An application calls the SubmitSQL method to submit SQL statements for execution on a database on a remote instance of SQL Server. When you call the SubmitSQL method, you can submit any SQL statement as long as it does not return rows.

Tasks

How to: Submit SQL Statements to a Remote SQL Server (Programmatically)