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