I wonder if any one can help with this one. SQL Server management is not my strongest skill :) I'm using a SQL Server login account via CF (cfuser). When I create a table via CF, the tables owner is "cfuser" rather than DBO. This is fine, until I try to do a BULK INSERT and get an error on the opentable statement. I can run the BULK INSERT on any of the tables owned by dbo.
I set up a new account, with sys_admin privileges and even this account can not run the BULK INSERT. Another funny thing is the owner account (cfuser) can also not run the BULK INSERT. Does any one know why this would be? Thanks :) Brook Davies ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
