[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

Bulk Insert / Load not allowed with SQL auth sysadmin account..

I have tried everything...not sure what to do
0
Mikeyman_01
Asked:
Mikeyman_01
  • 2
1 Solution
 
TempDBACommented:
Need more information. Does sql auth sysadmin account has proper permission on the text \csv files you are using for bulk inserts?
0
 
DcpKingCommented:
Can you show the error message you get, and the ccode you're using? Also, if you're sure it's correct, ask your friendly DBA to try to log in and run the code for you i he or she usually has "God" access, so you'll find out pretty quickly if it's your code or your access rights!

hth

Mike
0
 
DcpKingCommented:
So I assume that it was your access rights that were the problem ?
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now