This is really a question AND the answer, but I figured I would post it here for the record, since it took me a while to dig up the answer on Google, and to see if anyone had any additional pointers.
In MS SQL Server, you can use the GO keyword to indicate the end of a SQL statement which is processed separately from the rest of the batch. CREATE PROCEDURE x... GO GRANT EXECUTE ON x GO I couldn't get "GO" to work in a cfquery on MX 7.0.2 SQL Server 2005. I think it may be because it is a Microsoft thing... Apparently using a semi-colon ";" after each statement instead of the "GO" makes everything better again. Please comment if you know more on how this works, and thanks to http://www.kylehayes.info/blog/index.cfm/2006/7/10/Multiple-SQL-Statemen ts for tipping me off. ~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
