Welcome to Sign in | Join | Help
in
Home Forums Photos Downloads

Bulk Insert Question

Last post 02-08-2008, 4:11 AM by Ultima Mark. 2 replies.
Sort Posts: Previous Next
  •  01-08-2008, 1:14 PM 1299

    Bulk Insert Question

    OK, I have a couple of questions. 

    I have a database that I have to update regularly (daily).  On my development machine, I have a Stored Procedure to truncate tables and bulk insert the data.  It works fine.  However, when I try to do this on this server, I get this error:

    YOU DON'T HAVE PERMISSION TO USE THE BULK LOAD STATEMENT

    My question:  Are we blocked from doing this on Ultima?  Or is it something I have done? 

    If we can't do this, then my other questions are not important --

    Thanks

  •  02-07-2008, 9:52 PM 1348 in reply to 1299

    Re: Bulk Insert Question

    Did you submit a support ticket?
    William Eaton, MCSE
    iTech Computer Solutions, LLC
    www.itechcs.com
  •  02-08-2008, 4:11 AM 1352 in reply to 1299

    Re: Bulk Insert Question

    Hello,

    On a shared MSSQL server you won't be able to do this due to user permissions. Due to security issues we can't alter these permissions.

    Cheers,

    Mark 


    System Administrator
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems