This service object will allow you to execute SQL scripts directly the Smartobject, remotely to any SQL servers as long as you have the AD user/pwd or as long as the same K2 account is admin of both servers.

- .sql, .txt files interpreted and executed directly via the SMO

- every SQL operation accessible without an MSTSC, TeamViewer etc... connection to the server

- Two authentication methods offered (K2 Service account or specified admin account of a DB)

- Return results either as a value or as a .csv file (two separate methods)

You can find more info on it (French language only) using the following link Blog Article