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

Posted on 2012-09-07
Last Modified: 2012-09-12
I have tried everything...not sure what to do
Question by:Mikeyman_01
    LVL 25

    Expert Comment

    Need more information. Does sql auth sysadmin account has proper permission on the text \csv files you are using for bulk inserts?
    LVL 16

    Accepted Solution

    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!


    LVL 16

    Expert Comment

    So I assume that it was your access rights that were the problem ?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video discusses moving either the default database or any database to a new volume.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now