did this come through before? maybe a permissions thing =>http://msdn2.microsoft.com/en-us/library/ms188365.aspx Requires INSERT and ADMINISTER BULK OPERATIONS permissions
Wrap a cftry around the cfquery and dump cfcatch On 4/23/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > > Thanks for the suggestions guys, > > I just changed the user to sa in the admin panel for my data source and it > worked right off, whch would suggest this IS a permissions issue with my > DB > user, any ideas what rights they need? They currently have datareader and > datawriter access to the db but that's it. > > Thanks, > > Rob > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
