I have a massive trigger (9800 characters) that I need to update on approximately 3000 SQL server databases. I can’t update it via dynamic SQL because it’s over their 4000 character limit for dynamic SQL. It appears I also can’t update it via Lucee because I’m getting the same error message in Lucee that I get trying to run the query dynamically, “Incorrect syntax near GO.” When I run the query for one database in SSMS, it runs fine. Does Lucee have the same character limit for cfquery?
OS: Windows Server 2016 Datacenter
Java Version: 1.8.0_181 (Oracle Corporation) 64bit
Tomcat Version: Apache Tomcat/8.5.33
Lucee Version: Lucee 5.4.3.16