Is it possible to start the SQL Remote process from the database, or do you need to run the executable dbremote.exe?
Are there any stored procedures to start the message agent?
asked 15 Jun '12, 07:20
You can run the DBREMOTE program or use the DBRemoteSQL() function as part of the DbTools API but there is no particular way to start SQL Remote from the database engine.
However, you can start any external program by xp_cmdshell or call external functions, so that would be possible pathes.
If SQL Remote is to be used in batch mode (i.e. not in continuous mode) at the consolidated, one might use a database event to establish some kind of "pull replication": Say, you would like to send messages to the remotes when a "product" table gets updated. A trigger on that table could then trigger an event that would call SQL Remote automatically to generate according messages. Likewise, one could use a database event with a particular schedule to let SQL Remote run at specific times...