HMS has updated setting for my account on server to enable CREATE, ALTER, etc.
Consider issue resolved
> > HMS moved site to CF10 server. For the past 5+ years I've used
> scripting quite often to create and alter tables
> > for this site. Now when running script I receive error: Executing
> the SQL statement is not allowed.
> > I can confirm datasource, username, password, dbtype are all correct.
> > HMS reviewed code and CF Server setting and respond that everything
> is set up properly and should work.
> I suspect that the CF datasource is not configured to allow execution
> of CREATE and ALTER statements - there's an option right in the
> datasource settings for this.
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/ > http://training.figleaf.com/ >
> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
> GSA Schedule, and provides the highest caliber vendor-authorized
> instruction at our training centers, online, or onsite.