T-SQL (Bulk Insert)

Discussion in 'Databases' started by lowbo, May 24, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. lowbo

    lowbo

    I have been trying to perform a Bulk Insert using T-SQL with Toad for SQL Server. I receive an error saying I don't have permission to run this statement. Are we not allowed to use standard stored procs of SQL Server? Is there another way to load the data from a file, because single INSERTs is way to tedious.
     
    lowbo, May 24, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    bulk insert should be available for you to use.

    you may be trying to insert into a database that you do not have access to. eg. the master db

    quote:Originally posted by lowbo

    I have been trying to perform a Bulk Insert using T-SQL with Toad for SQL Server. I receive an error saying I don't have permission to run this statement. Are we not allowed to use standard stored procs of SQL Server? Is there another way to load the date from a file, because single INSERTs is way to tedious.
    </blockquote id="quote"></font id="quote">
     
    Bruce, May 25, 2004
    #2
  3. lowbo

    lowbo

    Here is the response from Tech Support if anyone in the future runs into this problem.

    Sorry that we do not allow BULK INSERT in our shared SQL environment. We cannot allow that since only sysadmin and bulkadmin fixed server roles can perform BULKK INSERT, which we cannot add customer to in a shared environment.

    Thank you

    DiscountASP.NET
    The power of ASP.NET for less
     
    lowbo, May 26, 2004
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    Oops..

    [:I]

    quote:Originally posted by lowbo

    Here is the response from Tech Support if anyone in the future runs into this problem.

    Sorry that we do not allow BULK INSERT in our shared SQL environment. We cannot allow that since only sysadmin and bulkadmin fixed server roles can perform BULKK INSERT, which we cannot add customer to in a shared environment.

    Thank you

    DiscountASP.NET
    The power of ASP.NET for less
    </blockquote id="quote"></font id="quote">
     
    Bruce, May 27, 2004
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page