Mike, Thanks for responding. Another thing I forgot to mention is that when I run the procedure in SQL Server directly it runs without error.
Also, and this is sporadic. When I run the stored proc in coldfusion by itself, by doing an Exec statment in a CFQuery. Sometimes it runs without error. >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. > >Maybe the CF code is running twice, the first is working and the >second is failing. > >-Mike Chabot > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:329629 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
