MS SQL 2005 Bulk Insert

dman

Perch
I'm trying to update a MS SQL DB for a client and when I try to use BULK INSERT I get the error message:

You do not have permission to use the bulk load statement.

Can this be enabled? Is there a reason I the permission is not available? Thanks!
 
Bulk insert action required some admin level privileges which we do not allow on shared database servers due to security reasons as other user databases on same server. Security is always a balance between ease of use and accessibility
 
Thanks for the info and details. Any other easy or quick options for importing data? When I use Insert Into or the MS SSMS import option, it takes over an hour for the import of 200,000 rows. I was hoping Bulk Insert would be faster.
 
Back
Top