Is there a way to execute a Create Trigger SQL script from a process?

Hi,

I have a scheduled process that executes multiple SQL scripts.
The final of these scripts recreates triggers dropped in the first script.

Since triggers can't be created in a Stored Procedure; I am unable to use the Execute Stored Procedure smart service and, due to the scripts complexity, use the Query Database smart service.


Is there another way this can be executed from the process model?

Thanks

  Discussion posts and replies are publicly visible