I'm attempting to run this I have values assigned to the variables above but removed them in my screenshot.
When trying to run this in Ignition I get an error about The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Windows Authentication. Any guidance on what I should do to get this working. I have an Ignition SQL user for all my DB connections and don't want to switch to a actual window users to get this working
JDBC doesn't officially support SQL scripts. Just statements. Some JDBC drivers implement some SQL scripting syntax, but you are kind of on your own. If you really need to run a script in your DB, use a stored procedure. An SP can be called with a single statement.
2 Likes