If you have control over the server, why not execute a dts package via a stored procedure? It's so much easier...
-- jon mailto:[EMAIL PROTECTED] Monday, September 9, 2002, 7:13:02 PM, you wrote: BD> I wonder if any one can help with this one. SQL Server management is not my BD> strongest skill :) I'm using a SQL Server login account via CF (cfuser). BD> When I create a table via CF, the tables owner is "cfuser" rather than DBO. BD> This is fine, until I try to do a BULK INSERT and get an error on the BD> opentable statement. I can run the BULK INSERT on any of the tables owned BD> by dbo. BD> I set up a new account, with sys_admin privileges and even this account can BD> not run the BULK INSERT. Another funny thing is the owner account (cfuser) BD> can also not run the BULK INSERT. Does any one know why this would be? BD> Thanks :) BD> Brook Davies BD> ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
