If you don't have access to SQL profiler, find someone who does to help you or request permissions. You can't be expected to do your job without a full tool-set. Also, the debugging feature of a product such as SeeFusion when using the JDBC URL wrappers can be invaluable and easier to use than SQL profiler (though not nearly as in-depth).
What's the chance the processing page (and the proc) is getting run twice? Put in something like a cfmail after the proc runs so you will know every time it runs. Also, how many insert statements are in the proc? Unlike CF, SQL's default behavior is to continue execution after an error and unless you are using transactions properly some of the statements might be running fine, while others are erroring. ~Brad -------- Original Message -------- Subject: Re: Stored Procedure throwing error in CF but ran successfully From: Ali Awan <[email protected]> Date: Wed, January 13, 2010 3:43 pm To: cf-talk <[email protected]> >The best way to troubleshoot this issue if it is reproducible is to >start a SQL Server Profiler trace to observe exactly what the database >is doing. >-Mike Chabot > > >> Mike, I am trying this at work and do not have the admin privileges to run >> the SQL Server Profiler. Another interesting thing is that I created a separate page, to run the procs, and that worked. When I run the page within my specific app, it fails and throws this error. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
